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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors