topic Re: PowerBI Client issue ("element as type incompatible with the array") after SharePoint in Developer

PowerBI Client issue ("element as type incompatible with the array") after SharePoint 13->16 upgrade

bartp — Wed, 08 Jun 2022 11:49:28 GMT

I'm getting error when trying to get PowerBI report:

using Microsoft.PowerBI.Api.V2; using Microsoft.PowerBI.Api.V2.Models; // ... UserPasswordCredential userCredential = new UserPasswordCredential(Username, Password); AuthenticationContext ctx = new AuthenticationContext(AuthorityUrl); Task<AuthenticationResult> task = ctx.AcquireTokenAsync(ResourceUrl, ApplicationId, userCredential); AuthenticationResult authResult = task.Result; if (authResult != null) { TokenCredentials credentials = new TokenCredentials(authResult.AccessToken, "Bearer"); using (PowerBIClient powerBIClient = new PowerBIClient(new Uri(ApiUrl), credentials)) { // ... } }

Error:

System.ArrayTypeMismatchException: Attempted to access an element as a type incompatible with the array.
at System.Collections.Generic.List`1.Add(T item)
at Microsoft.PowerBI.Api.V2.PowerBIClient.Initialize()
at Microsoft.PowerBI.Api.V2.PowerBIClient..ctor(Uri baseUri, ServiceClientCredentials credentials, DelegatingHandler[] handlers)

It works on SharePoint 2013. After upgrade to SharePoint 2016 started getting this issue. Parameters to connect and get PowerBI report are the same in both cases.

I found one solution with trying different versions of Newtonsoft.Json library, but it didn't help

Re: PowerBI Client issue ("element as type incompatible with the array") after SharePoint

Anonymous — Mon, 13 Jun 2022 05:55:28 GMT

Hi @bartp ,

What kind of embedding method are you choosing to use in Sharepoint 2016, publish to web?

As far as I know, the classic SharePoint Server is not supported with embedding to SharePoint Online.

For reference: Known issues and limitations

According to your screenshot, I think there should be something wrong in authentication. I think you can try to delete the cache , then get the embed code and bear token and try again.

Here is a solved post with similar problem like yours, I hope it could help you solve your problem.

For reference: Embed Power BI report on SharePoint on-prem page, SP List as data source & repeatable deployment?

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: PowerBI Client issue ("element as type incompatible with the array") after SharePoint

bartp — Mon, 13 Jun 2022 14:23:58 GMT

I have found that:

On machine where it works with SharePoint 2013 - it works only if opened from different machine. When opened on the same server where it is deployed, it is the same issue.