Showing results for 
Search instead for 
Did you mean: 
Not applicable

“An unexpected error occurred” -- Direct Query SQL connection with Enhanced Dataset Metadata


We get this error from PowerBI Server when we try to run a report with a direct query SQL connection to a SQL Server when the preview feature “Enhanced Dataset Metadata” is enabled.


We are running the latest builds (Jan 2021) for PowerBI Desktop and Server.

Our workaround currently is to disable the “Enhanced Dataset Metadata” preview feature on the desktop. However, Microsoft has indicated that they “ … aim to make the enhanced format generally available as the only option in the next release of Report Server.” from here.

We really need help on this now in order to continue running these reports in the next version of the PowerBI Report Server.

Would appreciate hearing from Microsoft Support on this – thanks in advance.

Super User
Super User

If you want to engage with Microsoft Support you would need to raise a support ticket which you should be able to do through your IT dept or MS Account manager or maybe also through 

Not applicable

Thank you for the guidance. I will check with my IT department to see how to move forward with this. Meanwhile, I would appreciate other suggestions from the users who might have faced similar issues.

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.