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.
Dear All,
Could you please advise, I want to get the table name and the column name on the Power BI report already publish to the Power BI Service via API. I'm using the https://api.powerbi.com/v1.0/myorg/datasets/f05ea9e7-3f77-45d3-af13-4581784ab656/tables however I get the error bellow, I make sure datasetid is correct as well as the token.
Hi @khoaphan ,
Based on the error message received, it appears that your dataset does not qualify as a push dataset. However, please note that REST API Push Datasets - Datasets GetTablesInGroup only supports push datasets. For further details, I recommend referring to the official documentation provided below.
Push Datasets - Datasets GetTables - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Dataset {dataset_id} is not Push API dataset - Microsoft Fabric Community
The problem is you are trying to retrieve the table on the exisiting dataset, which is created from PowerBI Desktop/PowerBI Service. In such case you couldn't able to use this API.
This API is supports only Push DataSet
So what is Push DataSet ?
Instead of creating the dataset from PowerBI Desktop/Service,you need to create it using API (Push Datasets - Datasets PostDatasetInGroup)
In the event that your dataset is not a push dataset, you can refer the following thread to get it:
Get table list:
Solved: How to get a tables list from datasets published w... - Microsoft Fabric Community
Get column names(for import mode):
Solved: How to extract all the column names from a 'Table'... - Microsoft Fabric Community
#"Column Names" = Table.TransformColumns(#"Previous Step", {{"Data", Table.ColumnNames}}),
#"Expanded Data" = Table.ExpandListColumn(#"Column Names", "Data")
Best Regards
Dear @v-yiruan-msft ,
Can I get it via API?
In the event that your dataset is not a push dataset, you can refer the following thread to get it:
Get table list:
Solved: How to get a tables list from datasets published w... - Microsoft Fabric Community
Get column names(for import mode):
Solved: How to extract all the column names from a 'Table'... - Microsoft Fabric Community
Hi @khoaphan ,
Please check if the following REST API can help you get the expected info.
Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards
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 |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
27 | |
3 | |
2 | |
2 | |
2 |