Forum Discussion

AugustoChaves's avatar
AugustoChaves
Icon for Advocate II rankAdvocate 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
Nathan_C's avatar
Nathan_C
Frequent Visitor
4 years ago

Hi AugustoChaves  

Have run into the same issue with a calculated table build off of two DQ tables.  The table was being used as a data source for a paginated report hosted on PB Service.  

 

I do not have a solution for issue but have eliminated the calculated table by pulling it in as its own DQ table, and I'm no longer receiving the gateway error upon refresh.  So to me this would point the issue to being the calculated table.  I did not attempt to try creating the calculated table through an other manner within Desktop.  

 

Would appreciate if a solution is identified or the issue is resolved that you update this thread with the outcome.

 

Much Appreciated.