Power BI

Refresh specific tables in your Power BI dataset using a Power Automate custom connector

I love the new Power BI Enhanced Refresh API: it allows you to do things like refresh individual tables in your dataset, override incremental refresh policies, control the amount of parallelism, ca…

This article describes the IN operator in Power Query. It checks whether a value equals one of many and is meant to simplify your code.

If you’re reading this blog, odds are you’re already familiar with the Power BI documentation. If there’s a feature in Power BI, there are a set of articles that describe its capa…

This post is a running collection of tools that I use for formatting and highlighting code in my blog. The code that I share mainly pertains to Power BI, but includes also Python and C#.

Creative labelling is often necessary in order to overcome specific formatting limitations, or just to have clarity on specific metrics.

In this post, I explain why External Tools are necessary & discuss the challenges in adopting them.

Since the start of the COVID-19 crisis, we are bombarded daily with graphics depicting exponential and rolling trends. These analyses are a powerful way to reveal trends in variable, incomplete and discrete data; however, interpreting them is more difficult.

This post describes the purpose of Coalesce and shows how you can simplify your M-expressions by removing unnecessary code.

Collect feedback on the Power BI report pages

Struggling to choose the right virtual machines for your Power BI Gateways? Worry no more with this insightful blog that will help make the decision easier.

We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filt

Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why

This article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected m

Join the public preview to enable additional settings for workspaces in Power BI

Welcome to the August 2022 update. Can you imagine it’s the last month of summer already? We are excited to announce a variety of new features such as the conditional formatting for data labels, new “Select sensitivity label” dialog, data loss prevention policy update and DAX editor improvements. There is more to explore, please continue to read on.

Power Apps embedded in Power BI report Recently, the P3 Adaptive Power Apps team spent some time participating in thought sessions around the topic of the

This blog walks through validating and monitoring your machine learning models in Power BI for insights of your data, predictions, and decision-making.

There are many things you can do in a Power BI report that aren’t super complex. Here are a few ideas to get you thinking! If Adam can do this, you definitely can! Shout out to Chris Hamill for this design! Chris Hamill: https://twitter.com/ChrisHamill17 Info Panel Video: https://www.youtube.com/watch?v=yYr_SlG8bpw Mastering Bookmarks: https://www.youtube.com/watch?v=xCMqWEvSkAs Custom Background: https://www.youtube.com/watch?v=0QvovI3aycs

Another week, another challenge! Summer holidays is the perfect time to run into challenges that you normally would not encounter or simply do not know about because they are fixed before you know.…

Tired of slow and inefficient data refresh process? Learn how to leverage Incremental refresh feature to speed up and optimize the data refresh!

Learn how to set up Apps in Power Bi to elevate the user experience giving your reports a professional interaction.

In our previous Power BI automation blog, we utilized the Power Platform in combination with Azure SQL to store refresh history of our datasets leveraging the Power BI REST API when on a Power BI shared capacity. A solution to manage Power BI dataset refreshes is particularly useful when data source refresh times are variable and end users need to know when dataset refreshes are successful. However, Power Automate and Azure SQL create two failure points. This solution also requires additional licensing cost in Power Automate to leverage premium data connectors to Azure SQL. So, how can we consolidate the number of tools we use and at the same time leverage the security features and access controls that Azure provides?

An new diagram of Power BI Datamarts is now available. It includes the technical components of a Power BI datamart. This blog post includes a brief summary of each technical component.

We are committed to helping our Azure Analysis Services customers unlock the enormous capabilities of Power BI as a superset of Azure Analysis Services through a smooth migration path to Power BI. As part of this effort, we are happy to announce today that Power BI has reached yet another compatibility milestone with the introduction of explicit Dataset Write permissions.

This post is an overview of the improvements made to Datamart’s Visual and SQL Query editor, which is currently in Public Preview.

Metrics visual is now available.