This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Create a report in the power bi desktop. Everything is normal and refreshed normally。
However, after the report is published to the power bi service and the plan refresh plan is created, the salesforce object data source credentials are frequently invalidated。
So that I need to log in to the report data source of the service one by one every day to refresh the report normally。
The problem is that I have many reports based on the salesforce object data source, and the process of logging in again to refresh credentials is very laborious。
What causes this problem?
How should I solve it?
How can I have a stable salesforce object data source?
Any suggestions can be put forward to me, thank the team!
This is one of the error messages:
| Data source error: | {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","parameters":{"ConnectionDetails":"{\"kind\":\"Salesforce\",\"path\":\"salesforce"}","CredentialType":"OAuth2","DatasourceType":"Salesforce"},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"expired access/refresh token "}}],"exceptionCulprit":1}}} Table: XXXXX. |
| Cluster URI: | WABI-US-NORTH-CENTRAL-C-PRIMARY-redirect.analysis.windows.net |
| Activity ID: | 8e19424b-9c4e-4706-8eb6-63ca06747b52 |
| Request ID: | 9c4b2f94-01b5-4589-9858-4c9a7c27f794 |
| Time: | 2022-12-14 00:33:10Z |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.