Query Model Expressions, Descriptions for Tables, Columns, Measures in the Power BI Service
This video is about how to query your Power BI semantic model to pull metadata like measure descriptions, measure expressions, column descriptions, data types, and table descriptions into Power BI as a source so that you can display it in visualizations. This makes documentation of your model a breeze and makes it much more contextual for your viewers!
QUERY used in the video:
= AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/" & WorkspaceName, SemanticModelName, [Query="select * from $SYSTEM.DBSchema_Tables WHERE TABLE_TYPE = 'SYSTEM TABLE'", Implementation="2.0"])
🛠️ RESOURCES
Query measures in the Power BI BIM file: https://christine-payton.com/bim-file...
Brian Julius’ post about using AI on BIM to auto-create documentation: / brianjuliusdc_documentation-of-ms-skateboa...
Documentation on Power BI model schema: https://learn.microsoft.com/en-us/ana...
⏲️ TIMESTAMPS
0:00 Intro/demo
3:05 Copying between models
4:14 Method 1: Querying your model in the service
5:15 TABLES
8:18 COLUMNS
10:27 MEASURES
12:43 Relating metadata tables
13:36 Show measure descriptions dynamically
18:52 Method 2: Querying the BIM file
▶️ RELATED VIDEOS
Query and show report metadata the easier way! • NEW Technique to Show Model Metadata
Schedule refresh on file sources in Power BI: • How to Schedule REFRESH on File & Fol...
Move file sources for Power BI to SharePoint: • How to change a Power BI file source ...
🪽 CONNECT WITH ME
Blog: https://christine-payton.com/
LinkedIn: / christinehpayton
🎁 SUPPORT THIS CHANNEL
Shop: https://shop.bi-ome.com/
#power bi #metadata #datamodeling #bestpractices
Watch video Query Model Expressions, Descriptions for Tables, Columns, Measures in the Power BI Service online without registration, duration hours minute second in high quality. This video was added by user Christine Payton 08 October 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,285 once and liked it 72 people.