Dax Summarized Table gets error o refresh

[majdkaid22]

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 Figures' which does not hold any data because it needs to be recalculated or refreshed.
Please try again later or contact support. If you contact support, please provide these details.

Activity IDd470bf28-98ce-47a7-829d-f9aa011f7091

Request IDbbaef8f9-ec05-d384-bebb-ed0715ba87eb

Correlation IDc13b7b26-1253-dd8b-f1f0-81d1f6c6e424

TimeMon Jul 29 2019 17:29:21 GMT+0100 (British Summer Time)

Version13.0.10246.182

Cluster URIhttps://wabi-europe-north-b-redirect.analysis.windows.net

Summarised Sales Figures = 
    SUMMARIZE(
        Users,
        Users[User Name],
        Users[First Name],
        Users[Last Name],
        Users[is Sales Users],
        Users[Sales Office],
        
"Funded Clients MTD",[Count of New Funded Clients MTD],
"Deposit $ MTD",[Deposits_USD MTD],
"Volume $ MTD",[Volume $ MTD],
"Funded Clients QTD",[Count of New Funded Clients QTD],
"Deposit $ QTD",[Deposits_USD QTD],
"Volume $ QTD",[Volume $ QTD],
"Funded Clients YTD",[Count of New Funded Clients YTD],
"Deposit $ YTD", [Deposits_USD YTD],
"Volume $ YTD",[Volume $ YTD],
"Funded Clients MTD Target Achieved %",[New Funded Clients Target Achieved MTD %],
"Funded Clients QTD Target Achieved %",[New Funded Clients Target Achieved QTD %],
"Funded Clients YTD Target Achieved %",[New Funded Clients Target Achieved YTD %],
"Deposit $ MTD Target Achieved %",[Deposits $ Target Achieved MTD %],
"Deposit $ QTD Target Achieved %",[Deposits $ Target Achieved QTD %],
"Deposit $ YTD Target Achieved %",[Deposits $ Target Achieved YTD %],
"Volume $ MTD Target Achieved %",[Volume $ Target Achieved MTD %],
"Volume $ QTD Target Achieved %",[Volume $ Target Achieved QTD %],
"Volume $ YTD Target Achieved %",[Volume $ Target Achieved YTD %])

These are all measures in the summarized table

Any idea what am I doing wrong here?

[v-piga-msft]

Hi @majdkaid22 ,

It seems that you have refresh problems in power bi service.

Based on the error message, I'm afraid that the underlying data source is not refreshed completely as the calculated table need to be calculated based on the fact tables.

For you case, you'd better open the report in power bi desktop and click refresh button to check if you will have this error, if you don't have the error, you could republishthe report to power bi service.

Best  Regards,

Cherry

[majdkaid22]

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

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]

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