cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
mkavcic
Frequent Visitor

DiscoverMonikers did not return an access token for DataSource with service email

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?

 

  1. Service email is a part of the group that is allowed in service principals to use PowerBI APIs.
  2. This group is a member of the app that is registered and used in API call.
  3. App has access to workspace that where paginated report is published.

What are we missing?

 

Thank you!

Mitja

2 REPLIES 2
mkavcic
Frequent Visitor

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?

alonyeshurun
Microsoft
Microsoft

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.