Forum Discussion

majdkaid22's avatar
majdkaid22
Icon for Helper V rankHelper V
7 years ago

Dax Summarized Table gets error o refresh

HI guys,   The below dax table is running fine on desktop, but when scheduled refresh happens on service, I get the attached error    The query referenced calculated table 'Summarised Sales Figur...
Need Help
majdkaid22's avatar
majdkaid22
Icon for Helper V rankHelper V
7 years ago

v-piga-msft  thanks for your reply. When dataset is refreshed on the desktop, I get no error whatsoever.  It's only happening when scheuled refesh on the service triggers. sometime I get the results on the service without error, and some other times, I get the error mentioned earlier.

 

I understand this has to do with refresh is not being 100% on the dataset. What is the solution or workaround for this? 

 

This seems more of Power BI service refresh issue? 

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi majdkaid22 ,

For your scenario, I'm afraid that you'd better create a support ticket in power bi support to get the most efficient solution.(If you have power bi pro license that is for free.)

Best Regards，

Cherry

 

  • MarkSL's avatar
    MarkSL
    Icon for Helper V rankHelper V
    7 years ago

    Hi majdkaid22 ,

     

    Did you find a fix to this issue?  I've also got two simple DAX calculated tables which fail with the same error when in the service.

     

    Thanks

     

    Mark