Power BI

Did you know you can retrieve some header data with Power Query that your web call returned? Check out how the function Value.Metadata does this for you.

This article describes the behavior of the DAX functions that manipulate sets; they are useful to create queries and sometimes also to author measures. In t

One of the great news in Microsoft Ignite 2020 is the announcement of a new licensing plan for Microsoft Power BI, called Premium Per User, or Premium Gen2. In this article, I'll explain what that is, and how this can be helpful for Power BI users. Power BI Licensing To understand the Premium Per User…

Announcing the availability of Power Automate Desktop getting started videos and community forum. These range from getting started building your first flow, to working with Excel and invoice processing.

Data source management in admin center

October release of gateway

Most of the time I’ve spent looking at Power Query Query Diagnostics data, I’ve been looking at data for a single query. Over the past few days though I’ve spent some time investi…

What would an epic battle be without champions? Lost. The epic battle would be lost without champions. Don’t let this happen to you battle to build a data culture. Instead, find your champion…

Have you ever heard the term “Excel hell”? Odds are, if you’re reading this blog you’ve heard it, and possibly lived it once or twice. If not, you may want to take a minute …

Working with a Golden Dataset in Power BI is considered as a best practice. But how to proceed if you decide to split up dataset and reports later?

Getting more insights in the telemetry of your Power BI dataset is always interesting. Especially if you share your Power BI dataset for self-service purposes to build new reports on top of your ma…

I am not trying to take Microsoft out of business, but after I read on the Power BI team’s blog that the anomaly detection feature was coming, I decided to see if I could implement something …

As the name suggests, a multi-kpi comparator allows you to compare multiple KPIs or measures on the same chart. This way you can dramatically reduce the clutter on your Power BI report page. You ca…

The Power BI team at Microsoft publishes a “release plan,” which is essentially the public product roadmap. Anyone can use it to understand what new capabilities and improvements are planned, and …

Speed up Power BI report performance by reducing the number of visuals on a page

As a Power BI developer I know how Power Query makes it easy to get data from web sources, but I also know there are limits to what it can do. I can get data from tables on web pages, I can get dat…

During this new Microsoft Ignite format, with 48 hours of hours of digital sessions and interactions where thousands of IT professionals will come together, we have several exciting innovations to announce that will help customers drive clarity when they need it most.

Compare DAX and M formulas in Visual Studio Code is really easy with the help of Power BI Sidetools. As it is possible to transfer DAX and M formulas from Power BI desktop to files and to open them in Visual Studio Code, it is possible to compare two files. That’s extremely useful in many cases. Y...

Power Apps Checker for XrmToolBox creates a rich experience when validating the quality of solutions for CDS, Dynamics 365, Power Apps Canvas Apps and Power Automate flows.

In this PowerApps blog, I will explain to you how to create navigation in PowerApps using gallery control. Here we will also maintain the Navigation items in the SharePoint list so that we can make …

#Project #Management outline from initialization to closeout put together using PMBOK's 5th edition Guide as a reference. All text files can be downloaded from my repo and ready for use for your own PM journey.

A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort

September 2020 gateway release

Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related …

I love Power BI On the 23rd of September at the Microsoft Ignite conference, Microsoft announced changes to Power BI Premium, and introduced a Power BI Premium Per User license. This sounded a bit …