cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srinivastech
New Member

Powerbi service giving issue with refresh on direct query that contains calculated tables

"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh over a dataset with a calculated table or a calculated column which references a Direct Query data source is not supported."}}],"exceptionCulprit":1}}}

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @srinivastech 

That's one of the limitations using DQ connection. Some dax measures and calculated columns are not supported in the service.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi Thankyou for your reply, but surprisingly in my dev workspace it is working, though the summary table don't show the latest, but a schedule refresh had done the job, but this error is coming in my Qa work space.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors