Power BI

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 »

This is an off topic post for me (ie not Power BI), but then again – who doesn’t want to be more productive, right? I am a heavily process driven person and I like to organise and plan my days, weeks and months so I can be as productive as [...]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…

In this article, I’m going to show how you can use Visual Studio Code to run queries against a Power BI model. Usually, this is the kind of task you would use the excellent DAX Studio for, bu…

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.