All about BI, Modelling, DAX and MS BI
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.
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...
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.
This was an interesting case I did a while ago where they wanted to have a report that automatically provided a set of filters to the users, but not just any filters, no special filters tailored to them based on location and position in the organization. In this blog post we’ll look at how you can achieve this using RLS without actually securing the data. Before we start let’s look at the end result, on...
One of the questions that I get asked sometimes is how to prevent users from creating groups / workspaces in Power BI. I recently found out this is actually possible and we’ll in this blog on how you can set that up. But before we continue it is good understand how workspaces in PowerBI currently work. Whenever you create a workspace it automatically creates a group in Azure AD and Office 365 with the same...
So recently I created a new SSAS memory report that you can use to analyze the memory usage of your SSAS servers, read more on the actual report here. In this blog post we’ll look at how this report was build.
I have created several version of the SSAS memory usage report here and here. But with the new 1200 compatibility level these memory reports stopped working due to the DMV’s not working anymore for these databases. So I decided it would be time to create a new one for all models with compatibility 1200 and up (so not for anything smaller then 1200), this time of course using Power BI. Here I can also use...
As you probably have seen is that Analysis Services is now available in Azure and you can read all about in this great blog post by Bret. I have spend a few days at the SQLClinic at SQLPass talking to many of you, one of the topics that often came up is on when it would make sense to use Azure Analysis Services instead of running SSAS on your own hardware or even on VM’s...