cancel
Showing results for 
Search instead for 
Did you mean: 

Error 'Couldn't load the data for this visual'

Hi,

I have been facing the following error for last couple of days. It has been working before few weeks. There is no change in the data and report for last couple of months. I just downloaed the march Power BI Desktop version and pulished the report. The following column is calculated column. 

 

Can you please check and help on this? 

 

Expression in SSAS model is - Date=RELATED(Dates[full_date])

 

The expression referenced column 'Table1'[Date] which does not hold any data because it needs to be recalculated or refreshed. Technical Details: RootActivityId: d039cf0a-0c04-4e4a-b1f1-25c2d2c07250 Date (UTC): 3/19/2018 5:03:41 PM
Please try again later or contact support. If you contact support, please provide these details.

Activity ID2ea4685b-5127-40db-9aeb-4bd7c8590469
Request IDece18c0e-3c0b-20ff-f1cd-5d54029d8530
Correlation IDdb2dcfc8-f851-8e1c-fc35-5e68f3649988
TimeMon Mar 19 2018 17:04:10 GMT+0000 (GMT Standard Time)
Version13.0.4687.143
 
Regards
Ven
Status: New
Comments
Community Support Team

Hi Ven,

 

I tested it but can't reproduce it. 

1. How about deleting the dataset in the Service and publishing the report again?

2. I would suggest you file a support ticket here.

create ATicket

 

 

Best Regards

Dale

 

Visitor

Thanks. I am able to reproduce the same in Power BI desktop as well. It looks like there is some compatability issue with the Power BI or Azure analysis service.

 

 

Visitor

This issue has been resolved after completing the "Process Database" for the model.