Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
patrickstr
New Member

Accessing PowerBI Dashboard with Service Principal credentials not possible

Hello everyone,

 

for a clients project, we created a powerbi dasboard connected to a serverless synapse analytics sql endpoint. The reports are published and functioning.

As the publisher of the dashboard puts his own token into the shared link, he has to renew the token every xy days which is not desirable. For that we want to change the credentials for powerbi accessing the synapse data to a service principal. 

What we did for that in synapse:
- created service principal (sp) with client id and client secret
- made the sp to synapse administrator for being able to access the serverless endpoint

- sp has storage blob reader to the storage container where the data linked to synapse is stored

(this setup works as desired and was verified by connecting to synapse and querying data via dbeaver. Thus, the azure part is set up as desired)

What we did for that in powerbi:
- followed this guide and activated the needed developer settings

- same for this guide 

- made the service principal admin in the powerbi workspace
- changed dataset credentials from originally using oauth login to service principal credentials

 

The error we get:

566b3f9c-1c86-4acc-98a9-ea7389e470d1.jpg

As soon as we revert the dataset connection away from service principal back to oauth, the report works again. As the synapse sql endpoint can be accessed with service principal credentials as well, the error can only be powerbi related.

Thank you in advance!
Patrick

2 REPLIES 2
patrickstr
New Member

Hello Ibendlin,

 

thank you for your response. I'm having trouble connecting with your answer. What is then the point of PowerBI allowing the user to connect to datasets using service principal connections when each report using this dataset then breaks with the generic error message above?
Is there any other solution sharing powerbi reports without having to renew the oauth token after a while?

lbendlin
Super User
Super User

Here's my take: A report has a UI.  A service principal is not a user and cannot look at UIs.  It can only work with the underlying data sources.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.