Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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.