Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

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 lik...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous , 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.

 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous , 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.