Error exporting paginated report connected to Power BI dataset

[xli629b]

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 report that used data from a Power BI dataset (a dataset that came from a non-paginated report in Import mode that I published to the Power BI service) it failed and gave me this error when I checked the export status: 

"RootActivityId(27d26fd5-446e-4c7a-abd0-2f63bb5a8df9): DmtsDataSource: DiscoverMonikers did not return an access token for DataSource: 'Workspace5_GenericDashBoard_IQ_ML', DataSourceType: PBIDATASET, CredentialType: SingleSignOn"

I tried checking that the credentials were set correctly on my dataset and checked that I could refresh my dataset, but I still got the same error when trying to export the paginated report.

[v-yiruan-msft]

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