Forum Discussion

AugustoChaves's avatar
AugustoChaves
Advocate II
4 years ago

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...
Need Help
faroukwahsh's avatar
faroukwahsh
Advocate II
4 years ago

Odd, refreshing a report with a calculated table that references a DQ to a PBI Dataset never worked for me on the service. Now I am thinking it might be source specific since you mention this wasn't an issue for you before. 

AugustoChaves's avatar
AugustoChaves
Advocate II
4 years ago

It would fail refreshing from Power BI Service but connecting through XMLA endpoint and processing the Database it worked.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi AugustoChaves ,

     

    do you remember which mode you used? Process Full runs into the same error that I would get when refreshing the dataset from Power BI Service ("Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery"). And Process Default and Recalc don't seem to update the data in the report.

     

    Best regards

    GSE