Show the refresh date\time in a Power BI report and dashboard

A short post today. Someone recently  asked me: “How can I show the date and time this data has been refreshed last in my report and dashboard?”.  Here are 2 simple tricks to help you visualize this. Show last refresh date\time To show the date and time of the refresh we need to store the date and time of the time refresh runs in the model itself so we can show it in a visual.... Read more

Time intelligence solved with modelling and crossfilter instead of DAX measures

A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through the model. The pattern was created by the great Greg Galloway from Artis Consulting and I am blogging this with his permission. This solution allows users to select time ranges from the model to be applied to any measure (and not build it in for every measure),  for example YTD,... Read more

Determine columns you don’t need using DMV’s in Power BI

Today a quick one that I came across while writing a different blog post that I will blog later. I know we have talked about it again and again but a good best practice is to remove any high carnality columns you don’t necessary need. This trick is not new and has been blogged about before in different places but I wanted to emphasize it again due to the importance. I was finishing up my... Read more

Use IsInScope to get the right hierarchy level in DAX

In the November release of Power BI desktop we introduced a new DAX expression that is really great. Working with hierarchies in DAX have always been a bit of a pain, especially in scenario’s where you need to change your calculation based upon the level that you are in. The scenario Let’s take a scenario where the business has some special rules to calculate totals. For each total in the hierarchy the results are pre... Read more

Embed Power BI reports in SharePoint online using Apps

Last week I was trying to embed a Power BI report into a SharePoint online page. I wanted users in my organization with a free license to be able to see the reports.  Sounds easy? I opened the help documentation and went ahead. Unfortunately it was not as easy as it seems as the documentation was missing one crucial point (this will be updated soon). Steps to get it to work In the end I... Read more

Separate business names from technical names using SSAS and Power BI

I have heard this question come up now and then where someone wants to separate the names and columns seen by users from the names and users used in SSAS and in the reports. The main benefit this has is that name changes will not result in broken reports. Turns out there is a neat trick that will allow you to do this. The trick is for you to add a translation to the model... Read more

Creating a Hyperlink with filters through DAX

Thanks to two recent Power BI features it now possible to generate a link on the fly using DAX to go to a new report and pass in any filters. (Alsop imagine linking to your favorite SSRS report !) In this blog post we will create a DAX formula that generate a hyperlink based on the filters in the report. The measure contains 2 parts, the first part is generating the right url to the... Read more

Showing KPI’s in a table or Matrix with Power BI

Got a question today on how we can do KPI’s in the matrix or table with Power BI, just like we can with PowerPivot through the KPI functionality there.  This is where the great SVG trick from David Eldersveld comes into play, you can read all about it here in his blog posts: https://dataveld.com/2018/01/13/use-svg-images-in-power-bi-part-1 and this post by Chris Webb with even more cool examples. In this case I am using his trick and a post I... Read more