Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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.