Forum Discussion

xli629b's avatar
xli629b
Icon for Helper II rankHelper II
5 years ago

Error exporting paginated report connected to Power BI dataset

I tried exporting paginated reports using the export to file feature of the Power BI REST API. I was able to export a paginated report that had entered data to XLSX. I tried the same with a paginated...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi xli629b ,

Based on this error message, it seems that the error is caused by the unsuccessful acquisition of the access token. Please check the contents of the following links and try to troubleshoot the cause of the problem.
1. Supported data sources for Power BI paginated reports

2. Considerations when generating an embed token

3. Troubleshooting for access token failure

GenerateToken can fail, with effective identity supplied, for a few different reasons.

  • Dataset doesn't support effective identity
  • Username wasn't provided
  • Role wasn't provided
  • DatasetId wasn't provided
  • User doesn't have the correct permissions

To verify which it is, try the steps below.

  • Execute get dataset. Is the property IsEffectiveIdentityRequired true?
  • Username is mandatory for any EffectiveIdentity.
  • If IsEffectiveIdentityRolesRequired is true, Role is required.
  • DatasetId is mandatory for any EffectiveIdentity.
  • For Analysis Services, the master user has to be a gateway admin.

Best Regards