Forum Discussion

adonovan's avatar
adonovan
Frequent Visitor
7 years ago

Receiving intermittent "invalid query locator" when refreshing Salesforce Object

Hi all   I have a report that is set to auto-refresh during the day.  Intermittently, at different intervals, the refresh will fail with "invalid query locator" for the same Salesforce Object each...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi adonovan 

When refresh failures, is there any visual broken on the report?

Could you refresh from Power BI Desktop successfully?

 

As searched, there is an article you could refer to

Power BI Error : “The exception was raised by IDataReader interface.”

 

Best Regards
Maggie

 

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

adonovan's avatar
adonovan
Frequent Visitor
7 years ago

Hi v-juanli-msft 

 

Apologies, I thought I had email notifications turned on, but I missed your response. 

Visuals are not broken when the refresh fails, I just see old data.

As I mentioned in my post, this error occurs intermittently with scheduled refresh in Power BI (published to powerBI web) and then when I manually refresh it, it succeeds with the refresh. If I dont manually refresh, the next scheduled refresh works by itself. It generally does this every day or two.