topic Re: Powershell cmdlet Get-PowerBIDatasource in Developer

Powershell cmdlet Get-PowerBIDatasource

rxt — Fri, 21 Aug 2020 13:49:28 GMT

Get-PowerBIDatasource -DatasetId 00ce0e46-11a1-4075-8e56-a9c1a9980808 returns following error

Get-PowerBIDatasource : Operation returned an invalid status code 'NotFound'
At line:2 char:1
+ Get-PowerBIDatasource -DatasetId 00ce0e46-11a1-4075-8e56-a9c1a9980808
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIDatasource:GetPowerBIDatasource) [Get-PowerBIDatasource], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'NotFound',Microsoft.PowerBI.Commands.Data.GetPowerBIDatasource

as an admin, I am able to get full datasets, workspaces list but for Datasource some datasetID return value correctly and some returns the error message. I would be greatful if some one enlighten me what is a reason behind this.

Re: Powershell cmdlet Get-PowerBIDatasource

lbendlin — Fri, 21 Aug 2020 16:38:10 GMT

Try it in the sandbox and see if you can replicate the error. Which of these calls are you attempting?

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasourcesasadmin

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasourcesingroup

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasources

Re: Powershell cmdlet Get-PowerBIDatasource

rxt — Fri, 21 Aug 2020 18:32:51 GMT

Thanks for the Response @lbendlin . I am novice user with admin rights. I found out an article that mentioned as below

That may be the real cause behind, I am testing if that is the case.

PS:

Just added myself as an admin on the workspace which I didn't have access before and was able to get the data source Information. Thanks to sqlchick writer.