BOOKARKS CAN SAVE PERFORMANCE – MICROSOFT POWER BI
How Bookmarks at Power BI can save performance at the underlying data source. The following article describes how it works: Bookmarks and Performance
Power BI Gateway – personal mode
Some thoughts/clarifications about the Power BI / Data Gateway (personal mode) In the last time a customer has installed the Data Gateway in the personal mode and he was very confused about: The managing at the powerbi.com Portal … and … Continue reading
Microsoft Power BI Composite Model
The following article will describe how to you the Power BI Composite Model. Also I will describe the filtering at Direct Query. –> Article Power B Composite Model
The following article describes how to set dynamically and automatically the pricing tier at a Azure SQL Server Database. I use this scenario by Power BI productive or POC scenarios, where I cannot determine the really usage of the solution … Continue reading
Dynamic hierarchically Role Level Security with Power BI / SSAS Tabular using SQL Server CTE
Introduction If you have an organizational hierarchically view on your data, the need is often that every manager wants to view the data of his lower nodes and employees. This includes that the manager of a manager wants also to … Continue reading
PowerPivot: Calculate Subtotals with Earlier
Anbei eine kurze Erklärung wie man mit PowerPivot/DAX Zwischensummen erstellt um u.a. Trends zu erzeugen: Beschreibung Beispieldatei: Daten