Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
srinivastech
Regular Visitor

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors