Get error from scheduled refresh but not get error when refresh manually on desktop app

[jeongkim]

Hi,

My PBI gets error like below from scheduled refresh(auto):

but without any change, with same data source, 

It deosn't get error when I refresh manually on the desktop app like below.:

'WO ID' which was cause of error above is shown well. 

FYI,

'WO ID' dax

and its data source 'WO No.' is Direct query from other PBI

[Anonymous]

Hi @jeongkim , hello Uzi2019, thank you for your prompt reply!

Please go to the semantic model settings>Gateway and cloud connections > make sure the gateway connections works well:

Please also check the refresh history for any clues:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jeongkim]

Hi,

It looks okay connection, and refresh history says Completed without error but actually 1 table get error. 

Activity ID: 44707044-abb0-456f-925c-6c8ac525485a
Request ID: 7c556f5f-e521-44a4-9355-243925231b70
Correlation ID: 89cf0b10-85a3-ecdb-397d-f639a02a2f24
Time: Wed Feb 05 2025 16:09:23 GMT+0900 (Korean Standard Time)
Service version: 13.0.25125.48
Client version: 2501.2.22731-train
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

[Anonymous]

Hi @jeongkim , thank you for your feedback.

Please try to add null-check logic to the calculated column, similar to:

IF(ISBLANK([WO ID]), 0, [WO ID])

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019]

Hi @jeongkim 

Publish your desktop verison after proper refresh then try to refresh from service just for testing to check whether it is causing an error again.

I hope publishing your desktop version would resolved your issue!

I hope I answered your question!

[jeongkim]

Publish your desktop verison after proper refresh then try to refresh from service just for testing to check whether it is causing an error again.  --> it is causing error again. 

Manual refresh or scheduled refresh are not working, only refresh from desktop and pulish is working. 

It is quite weird. 

[Uzi2019]

hi @jeongkim 

what error it is causing after publishing on service???

please share detail error.