Connection to Salesforce failing

[DouweMeer]

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? 

[v-yalanwu-msft]

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.

[DouweMeer]

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.