Error accessing SSAS Tabular

[Anonymous]

Hi

I have created SSAS Tabular model and it is deployed on Azure SSAS services. I am able to connet to SSAS model from Power BI and I can see my metadata (measures, dimensions) but as soon as I pull any visual with measure or any dimension attribute, I am getting following error message.

The query referenced calculated table 'DimEmp' which does not hold any data because it needs to be recalculated or refreshed.

[v-xicai]

Hi @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

Best regards

Amy Cai

[v-xicai]

Hi @Anonymous ,

Did you change the database name or did some other changes such as re-deploy changes to your SSAS model without refreshing the table partition?

Refer to links: https://community.powerbi.com/t5/Desktop/Azure-SSAS-expression-column-refresh/td-p/326040

                         https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c5950ffa-b3d6-44a0-bd5c-a747932ffa64/tabular-problem?forum=sqlanalysisservices

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.