Curious about PBIP folder structure in Power BI? Dive into the Mahabarata-inspired story on Power BI Developer Mode!

Buidl your own Real Time Intelligence Demo with Sample Data in Microsoft Fabric.

Slicing and dicing dates: A practical guide to the Power BI Timeline Slicer

When preparing data, we may meet a scenario that needs to split all values stored in a single column into structured rows and columns. Here I will share a simple method with M query.  

Scenario: 

In the use of Power BI Desktop, the Table visual is the first choice for most users to display data. However, there are some aspects of the Table visual that do not meet our needs well. For example, the font size cannot be changed according to the length of the word. Table visual can only set global font size. Or set the color of a part of the value according to the conditions. The conditional formatting settings of the Table visual affect the values in the entire cell. In this article, we will use DAX in conjunction with HTML to generate HTML Content visual similar to the Table visual to display data.

When working with customer data in Power BI, it's common to compare lists from different sources to identify missing entries. In this blog, we'll explore three different approaches to find missing customers from one table by comparing it with another using DAX functions.

A little over a month ago, Fabric arrived and it hasn't stopped causing a stir. The possibility of a capacity with all the Premium features and more, but in a pay-as-you-go style like Power BI Embedded, seems excellent to me.

In this article, I'm going to talk about the latest update to the SimplePBI Python library, which allows Pausing and/or Resuming BI resources. If you use Analysis Services, Power BI Embedded, or Fabric, and would like to save when these tools are not in use, then this code will help us perform these actions. Later, we can see how to add this to an Azure schedule for automation.

In this post, we will seee how to implement Page Level Security in Power BI. Page Level Security indicates restricting access of few pages in the report with the users. For example, there are multiple pages in the report and User 1 wants to see only single page and User 2 wants to see all the pages. Here's a work around to implement this:

Microsoft provides Power BI Report Builder to design paginated reports within the Power BI ecosystem. Paginated reports can create highly formatted, pixel-perfect reports suitable for printing or sharing as PDFs. With Power BI Report Builder, users can design these reports with precise control over layout, formatting, and data presentation, complementing the interactive and exploratory capabilities of Power BI Desktop.

Power BI Report Builder supports various data sources, allowing users to connect to different data types to create paginated reports. Some of the commonly used data sources include Microsoft SQL Server, Analysis Services, Power BI Datasets, Azure SQL Database, Oracle, Excel, XML, and CSV/Text Files.

In this blog post, our primary emphasis will be on integrating Power BI Datasets within Power BI paginated reports. We will consider one of the use case scenarios where I have a Power BI report that displays an invoice report specific to each user. This report includes numerous calculated columns and measures. To facilitate exporting the report as a PDF, we use paginated reports. Instead of recreating all the columns and measures manually in Power BI Report Builder, we can leverage the functionality of adding a Power BI semantic model.

In this post, we will use Sync slicer with the drill-through feature to dynamically calculate data over a period of time.

Dynamically formatting values in tables and graphs like below where all values are formatted using 3 significant digits. In most cases this gives a getter overview of the values when having both large and small numbers. You will also see how to use the formatting also when e.g. concattenating the value with a string like in the bartchart title below

Scenario: 

The Bing Map object in Power BI Desktop displays a wide area when you select a different province with the Slicer. To make the map roughly zoom in to the province level, you can use different levels of geographic locations or use latitude and longitude instead of only province in the Bing Map object. You can also use the Filled map feature of the Azure Map object.

Fuzzy queries by using DAX codes

Scenario:

Let's assume I have a factory with a large number of machines. These machines produce different products. The factory operates 24 hours a day.