Forum Discussion
RolandPlanet
2 years agoFrequent Visitor
Use Service Principal to Refresh data source in SharePoint Online?
I have a CSV file that is saved to a document library in SharePoint. I've published my report to the Power BI service and it's refreshing using my credentials. I'm trying to configure the data sour...
RolandPlanet
1 year agoFrequent Visitor
I've verified that these settings are all enabled:
- How can I confirm the app has been installed by the administrator of the tenant?
- How can I make sure that the user in the tenant has given consent for the app to be used?
I have regenerated the client key. I have confirmed that I am able to use the service principal through PowerShell to create Power BI workspaces, so I believe I have the correct tenant ID, client ID, and secret key.
I'm still unable to use Service principal as an authentication method for my semantic model in Power BI.
- When I use Application (client) ID as the service principal ID for data refresh, I get a "Failed to update data source credentials: The credentials provided for the Web source are invalid" error
- When I use Object ID as the service principal ID for data refresh, I get a "Application with identifier '***6d77bb' was not found in the directory 'Contoso'. This can happen if the application has not been installed by the administrator of the tenant or consented to by any user in the tenant. You may have sent your authentication request to the wrong tenant" error
3erdfvcas
1 year agoNew Member
Hi, did you get it to work? Because I have the exact same problem as you had.
I appreciate any update on that topic.
Best regards