Field Parameters: Applications, use-cases, and tips to excel — Recently Microsoft announced the public preview of field parameters in Power BI. Field parameters aim to provide an out-of-the-box feature to dynamically change the measures and dimensions in a Power BI visual. This article looks at a few applications and use-cases of the field parameters, the challenges they address, and…

A complete guide to mastering visual headers and icons in Power BI — Part 1 — Visual headers in Power BI offer a rich set of actions to the report end-users. A visual header in Power BI is the set of icons that pops up when you hover over a visual such as charts, maps, heat maps, etc. …

The pitfalls of using Native Database Queries to import data from SQL Server — Incremental refresh on the Power BI datasets has three significant benefits; faster refreshes, more reliable refreshes, and reduced resource consumption. Incremental refresh is designed for data sources that support query folding. …

A step-by-step guide to turning COVID-19 data into stunning Power BI visuals using Microsoft Azure offerings. — Cloud, Big Data, and Business Intelligence are the three buzz words of the decade. Everyone is talking about them. Everyone wants to do it. But no one tells you how to do it. …

A DIY guide to applying RLS in a Power BI dataset from a DirectQuery dataflow — DirectQuery and dataflows can address various kinds of problems in Power BI. For example, one of the untraditional problems DirectQuery with dataflows can solve is restricting access to data where facts update less frequently than the data access rights. This article will discuss how to set up RLS in an…

A short guide to monitoring Power BI Dataset performance and DAX queries in Power BI service — Power BI Desktop comes with an in-built Performance Analyzer to examine performance and DAX queries. However, there’s no equivalent tool to monitor performance or obtain DAX queries once the report is on the service. Or is there? This article will show you how to monitor Power BI dataset performance and…

A summary and overview of APIs and Embedded Analytics in the Power BI ecosystem — The capabilities offered by Power BI are extended beyond the Power BI service with the help of APIs and embedded analytics. APIs provide the flexibility to build automation, and embedded analytics enables developers to consume Power BI content from custom applications. This article will briefly discuss the available APIs for…

A summary and overview of content sharing and exporting options in the Power BI ecosystem — Collaboration is a critical aspect of Power BI as an enterprise reporting platform. Power BI offers multiple sharing options to collaborate and make the best use of data and insights to make informed decisions. This article will briefly discuss the sharing and exporting options available to Power BI users. …

A summary and overview of client applications available in the Power BI ecosystem to access Power BI content — Power BI offers several client applications and flexible options to business users and developers to consume Power BI content in applications and platforms of their choice. In this article, we will discuss the client applications and how their availability varies by the Power BI back-end platform. …