All about BI, Modelling, DAX and MS BI
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... Read more
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... Read more
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. Read more
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. Read more
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... Read more
Another interesting question that I got earlier this week is how to assign bulk Power BI licenses to users based on their group membership. Fortunately this turns out to be rather straight forward, as with many cases the fact that Power BI is build on top of the Azure Stack helps us out yet again. Today we will be using Azure AD Premium and the Enterprise Mobility Suite to achieve our goal. Read more
Just a quick blog post today to highlight one of the Power BI integration points that we get “for free” being part of the overall Microsoft clouds infrastructure. One of the coolest things to come out of the Azure AD area is what they call Azure AD Conditional access. I know this is already talked about before but I think it is worth highlighting a bit more. By configuring this you can control under which... Read more
I get asked this question a lot: “for my company xyz we want to set up an enterprise gateway, what machines or hardware should we buy?”. I always reply with the famous consulting answer “it depends”, unfortunately there is no silver bullet here but there is some information I can provide to help make a informed decision. Read more