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 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

 

General Comment
Need Help
Show and Tell
Tips and Tricks

6 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    1 year ago

    Hi Anonymous 

     

    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!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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's avatar
        Uzi2019
        Community Champion
        1 year ago

        hi Anonymous 

         

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

         

        please share detail error.

         

         

  • 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.