Refresh data stuck on Evaluating...

[TimoRiikonen]

This screen never gets a resolution because SLAIssues is dependent on FactJiraSLAms:

Both of these are Oauth queries.

I tried to redo both of them from scratch, but that didn't help.

I deleted the merge from SLAIssues and I believe I succeeded to update once after that, but after that this is stuck again.

[v-cazheng-msft]

Hi @TimoRiikonen,

If you only connect to one Oauth query and refresh it only, will the refresh still fail? Is the data amount large? If you filter your data with some filters in Power Query, will you refresh successfully?

Best Regards,

Community Support Team _ Caiyun

[TimoRiikonen]

If you only connect to one Oauth query and refresh it only, will the refresh still fail?

On report side, it says "Please apply or discard the pending query changes and then try again." so it fails.

On query editor side, it succeeded (slow).

Is the data amount large?

About 100 million lines and source system is slow, but I have been verifying that the issue is not with that.

I fixed my issue on the source side already by doing the merge in there and this integration works without issues.

If you filter your data with some filters in Power Query, will you refresh successfully?

I already do several operations to the data: reading it, adding calculated columns and sorting.