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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Prodigy
Post Prodigy

Connection to Salesforce failing

I'm connecting my report to Salesforce object and now, "suddenly" (haven't made changes), I'm getting errors. 

To me, it feels random. I got a couple of "invalid_query_location". Yesterday I had this one:


And today I got one:


What could cause these errors? How would I fix that? 

Community Support
Community Support

Hi, @DouweMeer ;

 Which authentication method do you select here? 

And may be You can talk to your Salesforce Admins to see if the Salesforce Cloud token can be extended (hopefully indefinitly) but otherwise you will need to do the steps listed here to refresh the token on a regular interval.

Re: PBI Service Salesforce Refresh fails with toke... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey @v-yalanwu-msft 

I do have an indefinitly token.

Yesterday the report ran fine-ish, it broke, but it broke peculiar because of a DAX expressions referring to a non-existing table, which it had no problem refreshing the report previously with that flaw in back then as well. 

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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