Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
majdkaid22
Helper V
Helper V

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

 

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?

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.