Forum Discussion

Mat_P's avatar
Mat_P
New Member
4 years ago

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