Category: Power Query parameters
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…
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….
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…
Configure table and column properties – Designing a Data Model
Configure table and column properties Once we have our relationships sorted, we can take a peek at our table and column properties. In Power BI…
Star schema – Designing a Data Model
Star schema A star schema organizes your data into fact and dimension tables. You can use dimension tables to filter the fact table. Dimension tables…
Define the tables – Designing a Data Model
Define the tables As mentioned in the introduction, once you’ve acquired your data, cleaned it, and organized it, you can start to model it. Usually,…
Using merge queries – Cleansing, Transforming, and Shaping Data
Using merge queries Merge queries are used when we want to merge or combine columns from multiple queries where some columns are different. This often…
Sentiment analysis – Cleansing, Transforming, and Shaping Data
Sentiment analysis A sentiment is a feeling or judgment of something and in the field of analytics, sentiment analysis is a type of language or…
Enriching data with AI – Cleansing, Transforming, and Shaping Data
Enriching data with AI Power Query also includes ways to enhance data using AI services from Microsoft. These features integrate with Microsoft Azure Cognitive Services…