Data & Analysis

Update your report based on a website

A quick hack today. Got this question from someone who needed to be able to update a report and show users that something had changed. This is easy when you have access to a database and can add data to it but in this case that…

22 January 2019

Data & Analysis

Use more variables in DAX to simplify your life

Today I ran across a pretty straightforward DAX challenge that is made so much simpler thanks to variables. So I decided to share it. Remember folks use variables for each and every measure (even if you don’t think you need them). It will prepare you for…

14 January 2019

Data & Analysis

Load the Latest Version of a File in Power Query

There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your Power BI reports. There are 3 common patterns that come to…

4 January 2019

Data & Analysis

Data Privacy Settings And Data Refresh Performance In Excel And Power BI

I have known for a long time that data privacy checks can have an impact on the performance of data refresh in Power BI and Excel, but on a recent performance tuning engagement I had the chance to observe just how much of a difference changing…

2 January 2019

Data & Analysis

Power BI And Column Order In M Queries And Dataset Tables

The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the columns in a table in alphabetical order. However there are a…

28 December 2018

Data & Analysis

Credentials, Data Privacy Settings And Data Sources In Power Query/Power BI

Recently I’ve been doing some more investigations into how data privacy settings work in Power BI. This is a subject I’ve blogged about in great detail already in a series of posts last year, but this functionality is so complex that there is always more to…

20 December 2018

Data & Analysis

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. Bron : Kasper On BI Lees meer...

19 December 2018