Forum Discussion

pborah's avatar
pborah
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Can't access entire organizational datasets using powershell

I installed the PowerBI cmdlets in powershell and connected my account. I'm a workspace admin and I'm able to see/access all datasets in all the workspaces in the online portal. However in Powershell using the following command -

Get-PowerBIDataset -Scope Organization

gives me the following error -

Get-PowerBIDataset : Operation returned an invalid status code 'Unauthorized'
At line:1 char:1
+ Get-PowerBIDataset -Scope Organization
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (Microsoft.Power...tPowerBIDataset:GetPowerBIDataset) [Get-PowerBIDataset], HttpOperationException
    + FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Data.GetPowerBIDataset

 

Any clarity on the issue is highly appreciated. Thank you.

 

Need Help
Show and Tell
Tips and Tricks
  • pborah's avatar
    pborah
    4 years ago

    Answering my own question here. Official documentations say that I need to be an "administrator" to be able to do this but it doesn't say what kind of administrator. Turns out you need to be a PowerBI Admin or an O365 admin to be able to do this,

1 Reply

  • pborah's avatar
    pborah
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Answering my own question here. Official documentations say that I need to be an "administrator" to be able to do this but it doesn't say what kind of administrator. Turns out you need to be a PowerBI Admin or an O365 admin to be able to do this,