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
AugustoChaves's avatar
AugustoChaves
Advocate II
4 years ago

This is not the same thing. Calculated Tables from a DQ Dataset used to work until March 29th, 2022 and then stopped working after an update. SSO is not in play here.

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