Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
We are using python app to export PowerBI paginated report connecting with service email.
When export call is run we get this error.
ERROR:root:Export for report XXYYZZ Failed: {'code': 'PaginatedReportInvalidDatasources', 'message': 'RootActivityId(2017fb09-9014-4bd3-866d-31e517f3475b): DmtsDataSource: DiscoverMonikers did not return an access token for DataSource: <pii>"XZY"</pii>, DataSourceType: PBIDATASET, CredentialType: SingleSignOn', 'details':
When we use personal email, export works.
We went thru all the steps in the link
Embed paginated reports in your Power BI embedded analytics application - Power BI | Microsoft Docs
What else should we check or change to make it work?
What are we missing?
Thank you!
Mitja
Thank you for your reply.
Two questions remain:
1. Was this changed in recent months as we used to run an api call with service principal account.
2. Is it known when this will be available for service principals?
Hi @mkavcic,
Exporting a paginated report with a PowerBI dataset as a data source is not supported yet for service principals.
Please check the limitations for exporting paginated reports in the following link - Export Power BI embedded analytics paginated reports API - Power BI | Microsoft Docs
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
2 |