Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a Semantic Model that connects to the Salesforce via Gateway.
When I refresh it by manually clicking Refresh Now - it succsessfully refreshes.
But when I schedule refresh - it fails with Salesforce authentication error.
I wonder why? In both cases it uses the same connection via same Gateway, correct?
What's different between manual refresh in the Service vs. Scheduled refresh?
Any ideas?
Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the Salesforce source are invalid. |
Ideas anyone?
Hi @iBusinessBI
My guessing is that the way you configured the gateway connection and there's a token expiration. Oauth2 vs windows credentials connection
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
The Gateway connection is Oauth2. Why should it behave differently when refreshing manually vs. scheduled?
Don't the two types of refreshes go via Gateway the same way?
User | Count |
---|---|
45 | |
25 | |
22 | |
20 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |