Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th

[AugustoChaves]

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 side. The error message is as follows:

{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery."}}],"exceptionCulprit":1}}}

[rajeswar_j1022]

Hello

Are you finding any solution for this issue, I am also facing same issue.

Would appreciate if a solution is identified.

Much Appreciated.

[kymramosrpo]

Hello everyone,

I, too, built a couple of calculated tables with data directly querying a Power BI dataset, only to find out that the report will fail to refresh once published in the service.

The workaround I came up with is not perfect but it works (also, this alternative might only work for smaller datasets...):
(1) create a flow in Power Automate to get the data from the PBi dataset and export as CSV* (way faster and simpler than exporting as an Excel spreadsheet) > (2) query the CSV file instead

My flow uses the Recurrence trigger, I just arranged the order of refresh and trigger schedules.

*Reference: Automatic exports of Power BI data 🤖 | Run a query against a dataset - YouTube, Curbal, @ruthpozuelo, Jun 20, 2022

I hope this helps!

[BeAStar]

was there any solution to this??? I've had reports that were auto refreshing without any issues and suddently they show this error.

[faroukwahsh]

There's already an Idea posted by a Microsoft employee reagrding this Premium_ASWL_Error - Single sign-on (SSO) credenti... - Microsoft Power BI Community

Please go in and vote on it. 

[AugustoChaves]

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]

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]

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

[GSE]

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

[Nathan_C]

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.

[AugustoChaves]

Hi Nathan, I have a support ticket opened and it's confirmed it's a bug/requires a fix. I'll post here when I get a response. Thanks

[AugustoChaves]

Hi GilbertQ, the gateway was already updated to latest version, March 2022, but that shouldn't have an impact since this is DQ to a Power BI Dataset (DQ to AS).

Thanks

[jamezcua9]

Posting to keep the thread alive. 
Still facing the issue IN 2024. Any roadmap to have a resolution on this? 

[StijnVnb]

Hi @AugustoChaves , any news or update from Microsoft? Did they communicate a timeline for the fix? Regards, Stijn

[AugustoChaves]

No timeline. Support is very poor and takes a long time to break 1st layer barrier.

I'm pressing for a date and will post here when I hear.

[GilbertQ]

Hi @AugustoChaves 

It could possibly be that there has been a change in the underlying calculated table?

There are often is changes to the Power BI Service. 

What happens if you try this on PBI Desktop does it work there too (Using the latest version of PBI Desktop)?

[AugustoChaves]

It seems like a chance at the service is the cause. In total 5 reports stopped working at the same time and there were no changes in any of them. I have a ticket opened but still no solution. Thanks!

[GilbertQ]

Hi @AugustoChaves 

Could you update your Gateway to see if that solves your issue?

[RhinoceRoss]

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]

No work around that I am aware of yet. 

It doesn't even support refresh through the Gateway. 

[RhinoceRoss]

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]

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.