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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
threepin
New Member

An error occurred while processing the data in the dataset

I had a report published on the Power BI Service and was running fine but the Power BI Dataset started failing with the below error:

 

 

 

MyReport has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. 
{"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}}}
Next refresh for MyReport is scheduled for February 23, 2023 22:00 UTC.

 

 

There are no calculated tables or columns in my model.

 

The refresh also works fine on Power BI Desktop. I'm using a composite model with one import table and one Directquery table. Wondering if anyone can give some guidance on the error and how to fix this?

1 REPLY 1
AnkitKukreja
Super User
Super User

Hi @threepin 

 

If you don't have any Calculated tables or columns then can you check if you are hitting any other limitations or if the settings are turned on correctly as suggested in the doc.

 

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

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.