Embedding Power BI Reports with Power BI Report Server
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...
Category: Microsoft BI
How it is build: the SSAS memory report
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...
New SSAS memory usage report using Power BI
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...
Analysis Services in Azure, when and why…
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...
Use SQL Server RLS with SSAS and Power BI
One of the questions I get regularly now that SQL Server supports RLS is how can to leverage this with SSAS. What many don’t know is that SSAS...
Improve performance with DirectQuery by using Inner Joins
If you have ever looked at the queries generated by DirectQuery you will see that a query that retrieves data from multiple tables gets joined...
Power BI Desktop Dynamic security cheat sheet
I recently created this simple Power BI desktop file that allows you to try out dynamic security with the new security relationship feature as described...
Use Task Scheduler and PowerShell to process your SSAS database
Most of the times you will use SSIS or a SQL Agent job to process a SSAS model, but sometimes you don’t have either one...