Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Can you please help us with the REST API through which we can fetch Columns used in the Report? We checked the Dataset and Report API but it didn’t show any results related to Column.
Thank you.
Hi @ekimakIA,
According to my research, I didn't find such a Rest API which can list the column information used in the report. The only Rest API I could find is the below one, and it supports only Push datasets. It will return the information about a dataset, including table names, column names and relationships etc.
Push Datasets - Datasets PostDataset
Also, I found some tools that can help you export the column information used in the report. Hope they can help you.
How to know where field from query is used? (Power BI Helper)
How to find where a column is used? (VertiPaq Analyzer )
Best Regards
Hi @v-yiruan-msft ,
I tried "Push Datasets - Datasets PostDataset" API and I created Dataset, Tables and Column in PowerBI through this API as shown in below screenshot
But I want to fetch this column details and I tried "Push Datasets - Datasets GetTables" API but in the result i'm only getting table name
Can you please help me with this and let me know like which specific REST API you have tried which gives information about a dataset, including table names, column names and relationships etc?
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |