Forum Discussion
Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th
Hello, Refreshes of datasets that contain calculated tables from DQ to AS started failing March 30th, 2022. This worked completely fine until March 29th which points to a change at Power BI service...
I've tested this a few different ways and I've found the specific condition that causes refresh to fail.
If you create a table in DAX that references a Power BI Dataset (i.e. a dataset outside of the the report being used as a dataset) refresh will fail.
For example. Say I have a dataset in the Service called 'DIM Date'. In my report, I can add that Power BI Dataset as a datasource and, in fact, I can add multiple external data sources, and I can also add local data sources in both DAX and Power Query. What I cannot do is create a table in DAX that references a Power BI dataset. For example, if I create a new table as:
MyDate = 'DIM Date', the report will not refresh in the service.