susannegov
commented
1 month ago See the page on setting up Best Practice Rules from Power BI blog post: https://powerbi.microsoft.com/en-ca/blog/best-practice-rules-to-improve-your-models-performance/
Requirements
- Tabular Editor 2 (free, open source)
- OR: There's also Tabular Editor 3 but it costs $$$
- Dax Studio (free, open source)
Steps
- After installing Tabular Editor, in your Power BI desktop file on the top header go to External Tools > Tabular Editor
Tabular Editor
- Copy/Past the code below to the C# Script in Tabular Editor. It's the same code in the blog post.
System.Net.WebClient w = new System.Net.WebClient();
string path = System.Environment.GetFolderPath(System.Environment.SpecialFolder.LocalApplicationData); string url = "https://raw.githubusercontent.com/microsoft/Analysis-Services/master/BestPracticeRules/BPARules.json"; string downloadLoc = path+@"\TabularEditor\BPARules.json"; w.DownloadFile(url, downloadLoc);
- Close and reopen Tabular Editor. It should show how many BP Issues on the bottom bar
- Click on the blue hyperlink for BP Issues. It should open to a new window called "Best Practice Analyzer" (BPA)
- Fill out any columns/measures with missing descriptions listed in the BPA
- `[Maintenance] Visible objects with no description`
- You can fill it on Tabular Editor or in the PBI desktop file. I found tabular editor to be slightly easier.
- In the left pane, expand Tables > expand the table missing description > select column/measure
- On bottom right pane, scroll to Basic > Description and fill out description. This will be used to generate data dictionary
- After descriptions are filled out on the table, click save
 and close in Tabular Editor.
- Save your Power BI desktop file. Keep it open since it will be needed for DAX Studio
## In DAX Studio
- Open DAX Studio. You should be able to connect to your Power BI desktop file as long as it is open.
- For Columns data dictionary, copy/pasteSELECT [DIMENSION_UNIQUE_NAME] as TABLE_NAME,[LEVEL_NAME] as LABEL_NAME,[DESCRIPTION] FROM $SYSTEM.MDSCHEMA_LEVELS WHERE [LEVEL_ORIGIN] <> 1 -- excludes User Defined Hierarchies AND [LEVEL_NUMBER] = 1 -- excludes the (All) level AND [CUBE_NAME] = 'Model'
- Select "Run" and check to see if correct by setting the output to "Results"
- If it looks good, change your output to "Static" with the excel icon. It will export the results as an excel table.
- For Measure descriptions, copy/pasteSELECT [MeasureGroup_Name] AS TABLE_NAME, [MEASURE_NAME] AS LABEL_NAME, [DESCRIPTION] FROM $SYSTEM.MDSCHEMA_MEASURES
- Select "Run" and check to see if correct by setting the output to "Results"
- If it looks good, change your output to "Static" with the excel icon. It will export the results as an excel table.
See #16880
Steps
I have made the data dictionary for columns and measures on the excel sheet. It's pulled from the description in the Power BI file itself. There are definitely a couple that could be better, but the most important ones - such as the measures are done sufficient. Most are copied from the open data portal