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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.