Power BI

Recently, I have presented a webinar about Driving a data culture in your organization. During this webinar, I presented what challenges you might face, what mistakes are made often and what you ca…

Using Power Query I show you how to embed your username and password authentication in the headers section of an API call.

Contribute to DavisZHANG-BlogOnly/dax-beautifier development by creating an account on GitHub.

This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. Many DAX newbies use

Until recently, I had not spent a lot of time building Power BI Reporting solutions that have SharePoint Online as a data source (This article refers to SharePoint Online specifically, but I am sure the experience is the same with on premise SharePoint). Over the last month or so I [...]Read More »

In the last two posts, I have explained what is Q&A visual and how we can define an adjective for each column. In this post, I will explain how to define a synonym for a column so if the business users use another word with the same meaning, still they able to use Q&A visual.…

Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. In this example, I am using Carbon dioxide emission data for each…

When looking to create dynamic column headers in tables and matrix in Power BI. This is one way where it will always change with your dates.

When looking to automate the storage of your datasets for the past 2 years, I show how you can do this using Power Query in Power BI

Previously, AutoML models could only be applied to entities in the same dataflow. With this new capability, users don’t need to be an owner of the dataflow that has the model.  They can use models created by others in the same workspace.

We’re pleased to announce two new actions are available for the Power BI connector in Power Automate. Now, you may easily leverage the Power BI export API for either Power BI reports or paginated reports in your workflows in Power Automate.

Imaging a scenario where your monthly sales are $80 while the budge value for sales was supposed to be $100. Obviously, you are not making your number. However, would you rather be 20% short but wi…

To start – this problem is fairly common, but also pretty niche. If this scenario does not work for you, hopefully it will at least spark some ideas on how to use conditionally formatted butt…

Calculation groups are a robust modeling feature in Power BI that reduces redundant measures created by grouping standard measure expressions.

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

The last few posts and videos in this series have introduced the importance of a community where your data culture can grow, and ways to help motivate members of the community, so your data culture…

This tip outlines an easy deployment method for data tables that have been manually added to a model via “Enter data” in Power BI Desktop. [...]

This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. This article contains a

The news about Power BI external tools have gone viral on the internet, and every day we see many useful tools added under external tools. The good news for those of you who have been waiting is that you can now have Power BI Helper also (even though a bit late in the game) to…

Q&A allows report readers to ask questions regarding the report data. Natural language interpretation can be improved by using Q&A synonyms.

We know that Excel is one of the most widely used tools in the world for understanding data and making decisions based on that data. It's used by hundreds of millions of users each month in almost every type of company imaginable. To better meet the needs of our users, Excel has evolved and transfor...

Choosing good colors for your charts is hard. This article tries to make it easier.

I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast ratio and get advice on how the two c…

In this blog post we cover features of the Power BI Service that could potentially compromise enforcement of your governance and security policies.

Power BI implementation key considerations from a non-technical perspective.

New documentation about what’s involved with migrating to Power BI is available on the Microsoft Docs site.