Posted on Power BI

Build your custom visual with Charticulator and Power BI

Recently I attended an excellent session by Andy Kirk on the state of data visualization for 2019. One of the tools Andy is most excited about is called Charticulator. For those of you that haven’t heard about it, Charticulator is an open source project from Microsoft Research. Using a web UI you can design almost any charts by interactively specifying constraints (NO code). The best news is that you can use these visuals directly in Power... Read more

Posted on Analysis Services DAX Power BI

Find all queries to Azure AS from a Power BI report or dataset

I recently found out the SSAS team added new trace information to Azure Log analytics. The new information allows you to find out the report and dataset in Power BI that generate each query. To show you how this works. I captured the queries in AAS using Azure Log analytics as I described here.  I then make sure I add the column ” ApplicationContext_s” using the query below. This will give me the context the query... Read more

Posted on Power BI

Refresh a Power BI dataset that feeds from SharePoint list automatically

The Power BI team recently shipped some cool new flow options and one of them is really cool. Many times I hear of reports and dataset that fully rely on SharePoint lists. These lists are used by business groups that don’t have the rights to spin up and Azure SQL database or just want to keep a simple list to store their dimensions. SharePoint lists are great for that. The new flow option allows you... Read more

Posted on Analysis Services DAX Microsoft BI

Figure out which columns and measures are used in your SSAS Tabular model

I got an interesting question about being able to figure out which measures and columns are being used for all tabular models in a server, either by known reports or by self service users using Power BI. To solve this I decided to use Power BI :). To get the required information I decided to capture and parse the queries being that are being send to AAS and parse the results Power BI desktop over... Read more

Posted on Power BI

Automatically rotate through Power BI report pages on your browser

This question comes up pretty regularly, I have a big screen in my hallway and I want to show some Power BI reports that rotate. Now there is some build in functionality in the Windows 10 App for Power BI for it that you can check out here. But there have been some cases where this doesn’t work, like for example if you want your report to run outside of your domain using B2B or... Read more

Posted on DAX

Using DAX variables in iterators

I was having a discussion earlier this week about the use of variables I used in my currency conversion blog post . The question was why I am using 2 different measure to calculate the sales for each currency. So I am using 2 measures together: TrnExchangeRate =MIN ( FactExchangeRate[Factor] ) and TotalSales =IF (    HASONEVALUE ( ReportCurrency[ReportCurrency] ),    SUMX ( FactSales, [Sales] * [TrnExchangeRate] )) As explained in the blog post the SUMX in this calculation will iterate over each row in the fact table which probably will have multiple currencies... Read more

Posted on Power BI

How to enable scheduled refresh for your custom connector

Here is a post that is long overdue as the functionality has been available for almost a year now. Today we will enable scheduled refresh to the Strava custom connector I build before. The trick to this is that we need to extend the code of the Strava connector with a “TestConnection” function as is described here. This will allow the Power BI gateway to know how to test the connection. Of course we will... Read more