This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.