cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vrocca
Advocate IV
Advocate IV

Using Get-PowerBIWorkspace PowerShell command

This may be a simple/dumb question, but I'm trying to get a list of Workspaces using PowerShell, and I'm getting an error "Attempted to access an element as a type incompatible with the array"

Error.png

 

 

What am I doing wrong?

 

Thanks,
Victor Rocca | www.victorrocca.com
6 REPLIES 6
kayu
Microsoft
Microsoft

Hi Victor, would you be so kind to head over to the githup repo of the cmdlets and file this as an issue under: https://github.com/Microsoft/powerbi-powershell/issues? I've seen this error before but it went away after I updated .NET and Powershell. Hope this helps.

Cheers,

Kay

Thanks Kay.

 

I have PSVersion 5.1 and .NET Framework 4.7. Do you have something different?

Thanks,
Victor Rocca | www.victorrocca.com

It looks like the issue was being caused by a Newtonsoft.Json conflict. 

 

"The issue is likely due to a mismatch in Newtonsoft.Json between the Power BI cmdlets and some other cmdlets loaded into PowerShell session (via profile or calling directly)"

 

More info here: https://github.com/Microsoft/powerbi-powershell/issues/60

 

Current workaround is to use Powershell Core

Thanks,
Victor Rocca | www.victorrocca.com

I was battling this error as well.  However, I was able to get by it by using a user that is a Global Administrator.  I would suggest double checking that as well.

 

 

it's a bit of a necro-thread reply, however i was able to work out what was going on...

 

Essentially it seems that Powershell only loads one version of each DLL (per session), no matter how many modules you are referencing it from. This of course makes perfect sense - UNTIL you first reference a module which uses an "old" version of newtonsoft.json.dll (I did a search, and had >50 newtonsoft.json.dll files on my PC with many different versions).

 

So the trick is, at the start of a Powershell session make sure you load a module which references a new enough version of the newtonsoft DLL

 

this did the trick for me. 

 

 

 

if (Get-Module -Name MicrosoftPowerBIMgmt -ListAvailable) 
    {
    Import-Module MicrosoftPowerBIMgmt -ErrorAction SilentlyContinue #workaround
    }

 

 

kayu
Microsoft
Microsoft

Hi Victor, would you be so kind to head over to the githup repo of the cmdlets and file this as an issue under: https://github.com/Microsoft/powerbi-powershell/issues? I've seen this error before but it went away after I updated .NET and Powershell. Hope this helps.

Cheers,

Kay

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors