topic Re: Error running Powershell Get-PowerBITable in Developer

Error running Powershell Get-PowerBITable

Anonymous — Thu, 21 Nov 2019 20:49:19 GMT

Hello,

I've experienced an error while running the following command:

Get-PowerBITable -DatasetId [My Dataset ID Here] -WorkspaceId [My Workspace ID here] . Error is as follows:

Get-PowerBITable : Operation returned an invalid status code 'NotFound'
At C:\Powershell Tests\Test.ps1:6 char:1
+ Get-PowerBITable -DatasetId ..... -Wor ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...GetPowerBITable:GetPowerBITable) [Get-PowerBITable], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'NotFound',Microsoft.PowerBI.Commands.Data.GetPowerBITable

Please kindly assist.

Regards,

Joe

Re: Error running Powershell Get-PowerBITable

Jayendran — Fri, 22 Nov 2019 06:08:11 GMT

Hi @Anonymous

As the error mentioned the Script couldn't able to find it the one which you are looking

Possible reason:

Either your datasetid/workspace id is wrong
The logged in user (from the powershell session) is not having permission to the workspace/dataset

~Jay

Pls join my upcoming webinar

Re: Error running Powershell Get-PowerBITable

Anonymous — Fri, 22 Nov 2019 14:54:15 GMT

Hi Jayendran,

It is strange, because I am setup as the Power BI Service Admin of our tenant.

I am confident that my datasetid/workspace id are correct (I got it by reading from url or running Get-PowerBIDataset -Scope Organization)

I am able to run the following and get data without issues:

Get-PowerBIDataset -Scope Organization

Get-PowerBIWorkspace -All

By removing the workspace id, error is : Get-PowerBITable : Operation returned an invalid status code 'Forbidden'.

Really need help from someone to understand what is happening.

Regards,

Joe

Re: Error running Powershell Get-PowerBITable

Jayendran — Thu, 28 Nov 2019 07:07:17 GMT

Hi @Anonymous ,

Ah now it's Forbidden error which means like you are not allowed. Can you try the same script in a new powershell session or window

Re: Error running Powershell Get-PowerBITable

Anonymous — Thu, 28 Nov 2019 15:14:14 GMT

Hi Jayendran,

Yes I did couple of times. But still have the same issue.

Regards,

Joe

Re: Error running Powershell Get-PowerBITable

Anonymous — Tue, 25 Feb 2020 19:42:57 GMT

Seeing the same behaviour here - did you ever find a solution?

Re: Error running Powershell Get-PowerBITable

Anonymous — Sun, 15 Mar 2020 20:43:20 GMT

No, I was not able to find any solutions on that.

Re: Error running Powershell Get-PowerBITable

MarianoCatalano — Mon, 22 Nov 2021 13:38:04 GMT

I am having the same problem, I am a Power BI Admin, when I execute the following command in powershell

Get-PowerBIDataset -Scope Organization | Get-PowerBITable

I get "Get-PowerBITable: Operation returned an invalid status code 'NotFound'"

Re: Error running Powershell Get-PowerBITable

lattali__ahmed — Sun, 27 Feb 2022 10:37:09 GMT

The command Get-PowerBITable is actually calling the REST API to get list of tables

Unfortunatly this only possible for push datasets at the moment

Check this link

https://docs.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-get-tables

Re: Error running Powershell Get-PowerBITable

Anonymous — Thu, 20 Oct 2022 13:06:17 GMT

This is answer!

Re: Error running Powershell Get-PowerBITable

ElhamBa — Thu, 03 Nov 2022 00:30:18 GMT

I have a same error when I am running Get-PowerBITable -DatasetId or Invoke-PowerBIRestMethod -Url 'datasets/{datasetId}/tables' -Method Get but I am able to run other admin command