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

[ven2k12]

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

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

Regards

Ven

[v-jiascu-msft]

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.

Best Regards

Dale

[ven2k12]

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.

[ven2k12]

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