Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
iBusinessBI
Kudo Collector
Kudo Collector

Semantic model refresh fails only when scheduled, succeeds when refreshed manually in Service

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?

 

iBusinessBI_0-1701948075549.png

 

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. 

 

3 REPLIES 3
iBusinessBI
Kudo Collector
Kudo Collector

Ideas anyone?

aj1973
Community Champion
Community Champion

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?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.