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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

Top Solution Authors
Top Kudoed Authors