Power BI

The team has been busy the last month shipping new features and fixes for you. You can view the weekly release information here https://aka.ms/PAWeeklyReleaseNotes . Check the release table, by region, to find out when these features and fixes will be available. Compose and reuse rich components and controls in canvas apps Makers can build and … Continue reading “February 2019 updates for Microsoft PowerApps”

In the first part of the series we basically dealt with the possibility of programming loops similar to those of other programming languages. We looked at the concept of recursive functions in M for Power Query and Power BI. In this part I would like to show you an alternative way to overcome the performance issues of conventional recursive functions in M. The function List.Generate()...

In the first two parts of the series "Programming Loops in M" we dealt with the basic possibility of creating loop constructs in M for Power Query and Power BI with the help of recursive functions or the function List.Generate(). In the last part of the series I would like to introduce you to a function with which you are able to create the "For-Next"-loop type in M. The function List.Accumulate().

The February 2019 release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencers. Key Influencers is Power BI’s first AI powered visualization. Microsoft has long incorporated AI capabilities in Power BI through features such as Q&A and Quick Insights.

Optimization has become one of my favorite topics. OK, I’ll admit it: it might be an obsession and a source of joy. My inability to optimize (queries, data models, and DAX) used to be a source of headaches and the occasional heart attack depending on what I was trying to accomplish. I make no claim that I’m an

Was looking at the PowerApps Docs on how to control the Power BI Filter context from inside of PowerApps and noticed a couple of issues…Like the references to our internal MSIT servers and an…

This article shows how to compute a running total over a dimension, like for example the date. A very common calculation in DAX is the year-to-date calcula

This post contains a PowerShell script that triggers a refresh process for three Power BI datasets. Additionally, this script is called/executed as part of automated processes via SQL Server Agent …

How, why and when to create your own Parameter Tables and the options that you have when trying to create one in Power BI / Power Query.

In this blog post FourMoo details how to use the new Power BI Rounded Borders feature to make stunning charts, which will enable better visualisation.

I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits. Microsoft is adding “Calculation Groups” to the DAX language. Th…

Introduction One of the first things that befuddles people that know other coding languages when learning DAX is the absence of constructs for traditional “for” and “while” loops. This is a well understood limitation and just generally accepted by people who have learned DAX. However, when answering...

Microsoft released the new Template Apps recently, and I am extremely happy to share my first App with you. It is publicly available on Microsoft AppSource. You can now explore Power BI Custom visuals via my Power BI Template App, and share it with your end-users in your organization for free from here. Do you …

Dependent drop downs, also known as “cascading drop downs” is the scenario where making one selection on a drop down filters the options available for selection on a following drop down. This is a common scenario across business forms in order to optimize the form filling out experience for the user. For example, filtering cities that … Continue reading “Configure easy dependent drop downs in PowerApps”

In modern BI projects, understanding the flow of data from the data source to its destination, and understanding the data transformation done along the way, is a key challenge for many customers. This challenge becomes even bigger if you have built advanced analytical projects spanning multiple data sources, artifacts, and dependencies. Questions like “What happens … Continue reading “Power BI data lineage experience for dataflows”

We are happy to announce that we have just released the February update for the On-premises data gateway (version 3000.1.257) This month’s Gateway update includes an updated version of the Mashup Engine, which matches the … Continue reading “On-premises data gateway February update is now available”

Microsoft has released its guidance and best practices: PowerApps and Microsoft Flow Governance and Deployment Whitepaper. It’s a great document, I highly recommend it for anyone considering …

We are happy to announce that we have just released the February update for the On-premises data gateway (version 3000.1.257) This month’s Gateway update includes an updated version of the Mashup Engine, which matches the … Continue reading “On-premises data gateway February update is now available”

Power Bi Service Dataflows is still underestimated. It is a revolution in Power BI and allows to perform your own data refresh logic, even the incremental refresh for some cases

With the release of CTP 2.3 of SQL Server 2019 today there was big news for Analysis Services Tabular developers: Calculation Groups. You can read all about them in detail in this blog post: In my …

Information, tips, news and announcements about Azure Analysis Services (Azure AS) and SQL Server Analysis Services (SSAS) directly from the product team.

Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it w

Last night I was scheduled to present this topic at the Power BI User Group in Portland except the meeting was cancelled because of a snowstorm; except the snowstorm didn’t happen… not …

Unstacking a column into a table made easy with an M-formula in Power Query and Power BI. No need to create a function if applied to all rows of a table.