Power BI: Tips and Tricks for Building Professional Power BI Model (and a star schema tutorial)

If you are relative beginner in Power BI / Business Intelligence, you will definitely benefit from this lab/tutorial. First, I go over the best practices with respect to designing your data model. I define dimensions and facts and why not thinking about the layout of your data leads to really bad model designs. After theory, … Continue reading Power BI: Tips and Tricks for Building Professional Power BI Model (and a star schema tutorial)

How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything

If your model started out in Excel, but now you are forced to connect to data in a database, you do not have to stress out. Yes, unless you watch this video, you will have to rebuild everything, but if you do watch this video, I will show you how you can move your table(s) … Continue reading How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything

Quirks of Visual Studio Query Editor working with Analysis Services

Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Services Tabular Model. Query Editor is a data ingestion and transformation tool used by Excel Power Pivot as well as Power BI. Now, … Continue reading Quirks of Visual Studio Query Editor working with Analysis Services

SAP BW Connector for Power BI – Support for additional member properties

October update¬†of Power BI Desktop was released a couple of days ago. One of the key feature update in this release is that the SAP BW Connector now supports additional member properties (attributes). Earlier version of SAP Connector exposed only text value of the BW object. To get additional member properties, we had to have … Continue reading SAP BW Connector for Power BI – Support for additional member properties