Power BI

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

Using Tabular Editor with Power BI, I show how to create a group with all the required values even if they are not in your dataset!

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 week it just happened that two of my consulting clients needed a date dimension table so I started revising my base Power Query template to make sure it was ready to share. After I improved my…

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.

In a previous article about Field parameters, I spoke about using them in cooperation with Calculation groups (LINK). I used them to get specific measures for selected dimensions from the dimensions field.

There is a hidden gem in the August 2022 release of Power BI Desktop: a secret new DAX function EvaluateAndLog that is not listed in the feature summary of the official blogpost. Yet this function …

My opinion on hiding the filter pane, what my personal preference is as well as the reasons why.

Describes enhanced refresh by using the Power BI REST API

Declutter and focus are two guidelines for creating clear and efficient visualizations.

One of the main challenges I see #powerbi admins of large enterprises is monitoring & troubleshoot all their on-prem Gateway Clusters. Each cluster has multiple gateway servers that are responsible to connect the Power BI service in the cloud to customer data sources, sometimes there are errors in t

This article introduces the Power BI workspace strategic planning decisions you should make at the tenant level.