When I add a calculated column to the Report, that I have did on SSAS Model, I'm getting this error :
The expression referenced column 'alarms'[HourOfDay] which does not hold any data because it needs to be recalculated or refreshed.
I have tried add more calculated columns and the same error shows for the visualizations that is using a calculated column.
Looks like Power BI doesn't support models with calculated columns and DirectQuery enabled.
Can someone confirm that ?
Compatibility Level: SQL Server 2017 / Azure Analysis Services (1400)
DirectQuery Mode: On
Hi @cheidemann ,
I'm sorry that I don't have the test environment for Azure Analysis Services.
In addition, I'm afraid that there are only two ways (import and Connect live) for us to connect the Azure Analysis Services Database in Power BI Desktop.
For you error message, please try this ways below.
1. Refresh the data source after you connecting the data in Power BI Desktop.
2. Save the pbix after loading the data and open it again to check if the issue will be fixed.
Besides, please check if you have installed the latest version of Power BI Desktop 2.68.5432.841.