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
Смотрите видео Query Model Expressions, Descriptions for Tables, Columns, Measures in the Power BI Service онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Christine Payton 08 Октябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,285 раз и оно понравилось 72 людям.