Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |