All about BI, Modelling, DAX and MS BI
I love cycling, both watching and doing it myself. One of the cool things is that is very data driven sport and thanks to Strava much of this becomes available to anyone, not just the elite athletes. Of course I would love to do more and get this data into Power BI. Thanks to Strava’s API’s and the new Power BI custom data connector SDK this is now possible! I started building this connector the...
With the new Power BI desktop release (July 2017) comes a new DAX function called “SelectedValue”, this DAX function is a convenience feature to help you with working with selections. Today when you want to use the value of a selection you always have to be careful, to get the value of the selection you can use the VALUES function, this works great when you always have a single value but when more than one...
One question that comes up regularly is how to use the firewall option of SQL Azure to open access to just Power BI. Now to use Power BI in general you can use the “enable azure services” option but for some customers this is not enough, they want to control the specific hosts (ip address) that can connect. Unfortunately at the time of writing Power BI doesn’t support having a single IP address, due to...
A common question I get is what will we will be able to do around embedding Power BI reports with Power BI report server. To understand this it is important to look at how the Power BI reports are being integrated into SSRS. The Power BI reports are really a new type of reports supported by Reporting services. In SQL Server 2016 we added support for mobile reports and now with Power BI Report Server...
Just a quick one today on how you can use the Power BI quick calcs with you own date table. I have a very simple table with a date column in it: Now I want to show the YTD over time (so crossing multiple years). It is pretty straightforward to do this: But I want a line chart that show a line at the day level (so a full date not day of year), unfortunately...
I got an interesting question today about using Always Encrypted columns with SSAS and Power BI and it turns out it this just works. Let’s take a look at how we can set this up.
Ok today a short one to show how easy it is to take your on premise SSAS cube over to Azure. You often see data migration tools and such for SQL and other platforms but for SSAS it is SUPER easy Let’s go.
Streaming data sets in Power BI are a cool feature that allows you to analyze data as it occurs. I was playing around with setting up this cool twitter demo using Flow as described here by Sirui: https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/ but was thinking, wouldn’t it be cool if I can get alerts based on the data that comes in. For example I want to get an alert when I get more than 20 negative Power BI tweets in...