Author: Noah Walker
XMLA endpoints – Connecting to Data Sources
XMLA endpoints XMLA is the communications protocol used by Microsoft SQL Server Analysis Services instances. XMLA is a widely used connectivity option supported by many…
Power Query parameters – Connecting to Data Sources
Power Query parameters For data connection and transformation, Power BI uses a technology called Power Query. Power Query is a key component of Power BI,…
Using your own date table – Designing a Data Model
Using your own date table You can either create a date table in Power BI or use a date table already in your data source….
Model size – Designing a Data Model
Model size Creating your own date table and creating relationships with all the date columns in your model will reduce the model size, sometimes significantly….
Design the data model to meet performance requirements – Designing a Data Model
Design the data model to meet performance requirements As mentioned previously, model performance is extremely important. A faster rendering report is a much more enjoyable…
Using sensitivity labels – Using Data Model Advanced Features
Using sensitivity labels As part of the holistic data protection capabilities, Power BI includes integration with Microsoft Information Protection (MIP). MIP provides sensitivity labels as…
Implementing row-level security – Using Data Model Advanced Features
Implementing row-level security A common security need for customers building reporting solutions with Power BI and needing to simplify the data model is a way…
Managing row-level security – Using Data Model Advanced Features
Managing row-level security In Power BI Desktop, you can manage roles and the DAX expression applied to each role by clicking Manage roles under the…
Using advanced operations of Power Query – Cleansing, Transforming, and Shaping Data
Using advanced operations of Power Query Power Query is truly a powerful tool for data transformation that helps to enable capabilities that often meet all…
The Advanced section – Designing a Data Model
The Advanced section In the Advanced section, you can choose to sort one column by another column in the same table. A common use for…