power bi Archives - {coding}Sight https://codingsight.com/tag/power-bi/ Blog for SQL Server DBAs and Developers Tue, 16 May 2023 13:20:37 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png power bi Archives - {coding}Sight https://codingsight.com/tag/power-bi/ 32 32 How to Set up Drill Through in Power BI Report https://codingsight.com/working-with-power-bi-drill-through/ Thu, 01 Sep 2022 02:43:00 +0000 http://codingsight.com/?p=16588 The Power BI Drill-through feature allows us to dig deeper into the data and get detailed information about a particular data entity. This article will explore the Northwind database to create a simple report that includes the Power BI Drill-through functionality. The script and the detailed information on creating the Northwind database on your SQL …

The post How to Set up Drill Through in Power BI Report appeared first on {coding}Sight.

]]> How to Create Paginated Report in Power BI: Definitive Tutorial https://codingsight.com/power-bi-paginated-reports/ Fri, 10 Sep 2021 06:44:39 +0000 http://codingsight.com/?p=16929 In this article, you will see how to create paginated reports using the Power BI Report Builder tool from Microsoft. You will also see how you can create parameterized paginated reports that display filtered data based on some parameter values. Table of Contents At first, you need to download the Power BI Report Builder tool …

The post How to Create Paginated Report in Power BI: Definitive Tutorial appeared first on {coding}Sight.

]]> Learn to Use Time Intelligence in Power BI https://codingsight.com/data-visualization-with-power-bi-applying-time-intelligence-to-reports/ Fri, 04 Jun 2021 09:05:08 +0000 http://codingsight.com/?p=14328 Time intelligence is a smart way of analyzing time period-based data, such as sales according to dates, using built-in time intelligence functions of Power BI. It is one of the most convenient ways because it eliminates the need to spend time on developing specialized solutions for your team.   The current article will focus on …

The post Learn to Use Time Intelligence in Power BI appeared first on {coding}Sight.

]]> How to Connect an Oracle ADW with Power BI and Create Sales Dashboard https://codingsight.com/sales-analysis-with-power-bi-desktop-and-autonomous-database/ Fri, 07 May 2021 09:52:18 +0000 http://codingsight.com/?p=13582 Oracle Autonomous Data Warehouse (ADW) is a fully managed and high-performance solution, turned and optimized for Data Warehouse workload. It means you don’t need to take more effort and resources (DBA role) to manage the database and optimize the workload. Power BI Desktop is a business analytics service by Microsoft. It offers interactive visualizations and …

The post How to Connect an Oracle ADW with Power BI and Create Sales Dashboard appeared first on {coding}Sight.

]]> Centralized Data Modeling Using Power BI Templates https://codingsight.com/centralized-data-modeling-using-power-bi-templates/ https://codingsight.com/centralized-data-modeling-using-power-bi-templates/#comments Thu, 06 May 2021 09:36:49 +0000 http://codingsight.com/?p=13349 The centralized data modeling approach is really helpful in many practical scenarios. This article focuses on achieving it using Power BI Templates and sharing the centralized Power BI data model across the organization. In addition, we are going to highlight the importance of maintaining common reporting tables in a central location for better management. In …

The post Centralized Data Modeling Using Power BI Templates appeared first on {coding}Sight.

]]> https://codingsight.com/centralized-data-modeling-using-power-bi-templates/feed/ 1 Power BI Date Table Template Tutorial https://codingsight.com/why-you-should-use-date-templates-in-power-bi/ Wed, 05 May 2021 08:24:11 +0000 http://codingsight.com/?p=13459 What is the right way of using Date Templates in Power BI reports and dashboards? This article will clarify the question and help to understand the usage of Date tables as templates. But before we dig deeper, let’s refresh the information we are already familiar with. The Date Template basics A Date table is one …

The post Power BI Date Table Template Tutorial appeared first on {coding}Sight.

]]> Power BI: How to Create Date Tables Using Dax Format Functions https://codingsight.com/how-and-when-to-use-multiple-date-tables-in-power-bi/ Tue, 27 Apr 2021 12:32:38 +0000 http://codingsight.com/?p=13040 To utilize the time intelligence built-in features and functions in Power BI reports, you can use multiple Date tables. This article is going to explore this case in-depth. The readers will get a conceptual understanding of professional life scenarios and the importance of using Date tables in Power BI solutions. Multiple Date tables are necessary …

The post Power BI: How to Create Date Tables Using Dax Format Functions appeared first on {coding}Sight.

]]> Create and Use Custom Date Hierarchies in Power BI https://codingsight.com/create-and-use-custom-date-hierarchies-in-power-bi/ Thu, 22 Apr 2021 12:51:42 +0000 http://codingsight.com/?p=12843 Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this issue. The current article focuses on the essence of custom hierarchies and using them for viewing the data in a Power BI report. What Is a Hierarchy? A hierarchy is a method of arranging the report data into an organizational top-down …

The post Create and Use Custom Date Hierarchies in Power BI appeared first on {coding}Sight.

]]> Creating the Date Table in Power BI Desktop Using DAX Function https://codingsight.com/how-to-create-date-table-in-power-bi/ Wed, 21 Apr 2021 12:30:34 +0000 http://codingsight.com/?p=12823 The time intelligence functions for the data models or databases running behind a Power BI report are really helpful. To make the most use of them, we can create a Date table on the Power BI desktop. This article focuses on the steps required to perform this task. Also, it highlights the importance of having …

The post Creating the Date Table in Power BI Desktop Using DAX Function appeared first on {coding}Sight.

]]> How to Easily Get Data from Web Source Using Power BI Rest API Calls https://codingsight.com/using-rest-api-as-data-source-in-power-bi/ Fri, 26 Feb 2021 13:57:26 +0000 http://codingsight.com/?p=12179 Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user interface. It can use a variety of data sources such as CSV, TSV, and other flat files, SQL databases, and even online sources through Rest APIs. This article explains the usage of Rest API as …

The post How to Easily Get Data from Web Source Using Power BI Rest API Calls appeared first on {coding}Sight.

]]>