Power BI

I used to work on a full-text search engine. Back then, we often paraphrased a famous Albert Einstein’s quote “Organized people are just too lazy to search”. In Power BI Desktop you can search for tab…

With this month comes the first feature release from our announcements at Microsoft Business Application Summit, Icon sets, which also addresses our current #1 idea on ideas.powerbi.com. On t…

In July 2019 Power BI Desktop released the ability to Icons in Tables & Matrix visuals. Hit hit tutorial on how to use these icons and and custom ones.

This month we are incredibly excited to announce that the new filter experience is now generally available. We have updated the look and feel and added a ton of new functionality. The new cap…

This blog post is an introduction on how to use Version Control in Power BI Desktop to allow for the PBIX files to be automated

Export data from visuals in Power BI has limitations that can be circumvented by a simple trick. Using DAX Studio with a automatically created query:

Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While it may not be the end of the world for a small …

A recent engagement brought an interesting dilemma. An ISV wanted to embed Power BI reports in a SharePoint Online portal accessible by their customers. The app handles user authentication and authori…

Video by: Reid Havens Learn about a great technique when applying measure-based conditional formatting to visualizations in Power BI. This technique will help significantly reduce development time.

What I wanted to do in this example is to show you how you can manage multiple dates in your Power BI tables. This is a very common issue I see that new Power BI users are experiencing with their development work. There's always a bit of confusion on how you actually set up the data model correctl...

To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple, has a significant impact on making your Power BI solutio…

As many data enthousiasts, I use Power BI on a daily basis to build dashboards and visualize my data. However, while building and…

Reading Time: 5 minutes Data sonification uses variations in audio to hear differences in data values. From an accessibility standpoint, data sonification offers another potential avenue to enrich your reports beyond methods pertaining to data visualization. There are a few pieces that need to be assembled to enable data sonification that works in both Power BI Desktop and Service. While, audio…

This blog post follows on from Part 1 where I now demonstrate how to check in, check out, view previous versions or rollback versions of #PowerBI PBIX Files

Take our survey to help us continue to improve copy vs. export related scenarios in Power BI.

Patrick looks at how to create and use a Power BI Hierarchy within Power BI Desktop. Hierarchies can help to provide correct data usage within your Power BI reports. Download sample Want to download t…

By embedding AI into so many areas in Power BI, content creators have many tools at their fingertips. One example is AI Insights, which blends machine learning into Power BI’s data transformation process.

I recently came across an interesting article on MSSQLTips for SQL Server Reporting Services that showed how you could use a T-SQL query as the parameter value, and have it return a table of data a…

You know that, too. A user calls you and asks when a dataset has been updated for the last time. What do you answer? I also had this problem but that is over now. And it will become only a memory for you, as well, if you read this article and implement the last timestamp of loading data into your da...

Understand a star schema and its relevance to developing Power BI data models optimized for performance and usability.

Our August release has another hotly anticipated feature from the Microsoft Business Application Summit, grouping. Grouping in reports, similar to PowerPoint’s grouping, lets you easily organize groups of visuals to move and resize them as a set. This month’s release also has some updates to our newest features, such as a icon set picker for our newly added icons conditional formatting and measure support for key influencers.

Here’s a process that allows you to add a password input box to your Power BI report. DO NOT, I repeat DO NOT use this for sensitive data.

Using disconnected tables in Power BI - An overview from BlueGranite's August session of Power BI Office Hours

There are some field properties in Power BI such as formatting, which is obvious to use. However, some configurations on the field level, such as Data Category, is not very well known. Data Category is a configuration that can be helpful in multiple visualizations, In this short article, I'm explaining how to use this option…

Unfortunately I wasn’t able to participate in the Microsoft Business Application Summit this year – but luckily we can watch all the session via But that would mean I had to leave Power BI De…

How many times you have been thinking to see is this possible to store the data of the Power BI report every day, every week or month. How many times, you thought of how to take a snapshot of the data…

Key Influencers visual is now generally available ( no preview ), so having updated version of the Power BI desktop, it is no more a preview feature. This visual is a good one for analysing the data. as I have explained in the post about it ( see here). Now let see some other features…

Power BI date slicers can be used to filter based on one field. However, what if in your dataset, you have a FROM and TO (or Start and End) Date? In that case, you’d most probably want to use the slicer to filter the report in such a way that it shows all data in…