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
RhinoceRoss's avatar
RhinoceRoss
Frequent Visitor
4 years ago

Hello all,
just wondering was thie issue ever resolved by power bi?

i'm starting to get the issue into a couple of my reports and im just wondering if it's a ME issue or a THEM issue.

if they didn't fix what was your work around?

regards,

Ross

aviral's avatar
aviral
Advocate IV
4 years ago

No work around that I am aware of yet. 

 

It doesn't even support refresh through the Gateway. 

  • RhinoceRoss's avatar
    RhinoceRoss
    Frequent Visitor
    4 years ago

    Thankyou, 

    yeah my  report dreams have been dashed this week with the gatway non refresh issue, having to think of a different approach.

    cheers 

    • AugustoChaves's avatar
      AugustoChaves
      Advocate II
      4 years ago

      According to the official reply on my support ticket this is not an issue, it’s a feature.

      I’m still owned an explanation on why it worked before and then it stopped working but I’ve given up on waiting and redesigned all reports that failed (5 or 6) from scratch.

       

      Thanks Microsoft! Very clear documentation, policies and procedures.

      • ManuGP's avatar
        ManuGP
        Advocate I
        3 years ago

        I support you AugustoChaves !Posting just to keep the topic alive, as it is still a problem in 2023.

        I use it to build effective dimension tables (based on data in the fact tables) with SUMMARIZE. It is also one of the things that work perfectly fine in desktop and there is no reason to suspect they wouldn't in the service until you publish and try to refresh.