Unable to generate token for paginated report

[josephrxavier]

Hi, 

We are trying to embedded paginated report to Asp.net MVC application. While trying for that facing issue on Generate token step and getting 'Bad Request' error. With the similar parameters we are able to generate token for regular PowerBI Report.

We are using Microsoft.PowerBI.API nuget package for generate token and embedd purpose.

Sample code :

var generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: View,
identities: new List<EffectiveIdentity> { new EffectiveIdentity(
username: userId.ToString(),
reports: new List<string>{ reportId.ToString()})});

tokenResponse = client.Reports.GenerateTokenAsync(groupId, reportId, generateTokenRequestParameters).Result;

Are we missing some parameter here?. Thanks in advance.

[josephrxavier]

Thanks for the suggestions. I tried to check more on embedding paginated report and found like we need to use service principal account for embedding instead of master user. So checking on this direction. Please correct me if it is wrong.

[AmosHersch]

Hi @josephrxavier ,

You can also try to see if you got any meaningful information in the response body. Sometimes it has more detailed info about the reason you got the bad request error.

Please note that some scenarios aren't supported, for example if your paginated report has a Power BI Dataset as a Datasource (that's coming soon), or if one of your Datasources is configured with SSO enabled.

[v-rzhou-msft · Accepted solution]

Hi @josephrxavier ,

According to the offical blog, steps of embedding paginated report is similar as embedding Power BI Report. Please check whether you have conigufred the capacity correctly.

Here are some offical blogs about how to Embed paginated reports.

For reference:

Embed Power BI paginated reports

Embed a paginated report

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.