Forum Discussion
PowerBI DataSet Refresh error when using service principal as datasource credential
I am getting an error when I set the Datasource credential to a service principal.
Error:
- Data source errorCOM error: Microsoft.ServicePlatform, Internal error Can't convert ServicePrincipal to proper M credential Type.. Table: AI_SLA_MONTHLY.
- Cluster URIWABI-WEST-US-redirect.analysis.windows.net
I created a query in Azure AppInsights and I exported that query to PowerBI as a dataset. I then changed the credential for the datasource "url":"https://api.applicationinsights.io/v1/apps/<log-analytics-id>/query" to my service principal. I used the Manage Connections and gateways settings menu.
Can someone help me figure out how to refresh this data as a service principal.
4 Replies
Hi PragmaticMan
When I have been using Application Insights I have used the AAD login credentials to get this successfully restoring.
Yes I can get AAD user credentials. I am trying to use a service principal credentials to access the data. Wondering if anyone can help specifically with using a service principal.
Hi PragmaticMan
You can follow the steps here under the section "Pre-Requisites Before Use"
Using the Power BI Scanner API to Manage Tenant's Entire Metadata -
Then once that is done add the AAD Group to the App Workspaces as as an Admin should allow it to then work!
