Understanding Power BI Concepts
How to delete all tables from a PBIX file?
In Model view, we can select multiple tables together and delete from Model. This will delete them from Power Query. However, you still have to remove references from each Visuals, Delete tabs for different layouts and base queries from Power Query Editor.
Difference between Copy/Paste and Duplicate Option in Power Query?
If a table is copied, it also creates copy of all reference queries used in it whereas duplicate will create exact independent replica of a table.
Hierarchy In PBI
- Adhoc: can be created dynamicaly in Visuals such as Matrix
2. Permanent: With in a table, it can help to pull all related fields together and customize.
Option to move Key columns to top of the table in Data Model View
In Layout, when nothing is selected, in Property Pane, highlight option gives move join columns to top of the table to make it easy to see them.
If you select a table and define Key Column, it can help in identifying which column contains unique values. If PBI doesn’t allow it for the column, it means we need to correct it in Power Query editor first.
Configure Model Checklist
- Configure Object Name and Descriptions
- Organize similar content in a folder
- Hide Objects
- Define Sorting
- Define formatting for Numeric and Date columns
- Summarization update for non-aggregate key columns
Data Categories
- Geographical Location
- URLs (Image and Web)
- Barcode (Only for Mobile App to filter report)
Add Synonyms to help Q&A
In Model view, for an Object synonyms can be added for terms Users can put in in Q&A Box.
Update Linguistic Schema for help in comparison based Q&A
Basic Steps to update Schema are:
- Under Model View — Linguistic Schema -Export
- Visual Studio Code ( Install yaml extension)
- Open file in Visual Studio Code and add properties with Adjective for comparison for a table and measure. Make sure correct indentations are used
- Import to Model
How to hide a Visual based on a Selection?
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
To be continued …