Forum Discussion
How to get a tables list from datasets published with Power Bi Desktop
Hello,
I would like to extract the tables list from datasets that are published on Power Bi Service that were generated by Power Bi Desktop. You can see them in the Power BI Service UI when you go to a specific dataset and click on "Show tables".
I have tried to use the Power BI rest API, the Get-PowerBITable to extract the list of tables that are included in a dataset. ( https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/get-powerbitable?view=powerbi-ps )
However, I get a message that says it can't find the table. "Get-PowerBITable: Operation returned an invalid status code 'NotFound' "
To make sure it's not an access rights issue I asked a colleague who has a Global Administrator role to try the same procedure and he gets the same message.
Is there anything I'm missing?
If not, do you have any idea how we could get the list of tables in another way?
Thanks
1 Reply
- AnonymousNot applicable
Hi Mat_P ,
Please review the following threads which has the similar requirement with yours, hope they can help you.
Get Table information from dataset Programmatically (check the last post from Anonymous )
Export a list of data source TABLES from a dataset (check the post from bhavikb )
Best Regards