“An unexpected error occurred” -- Direct Query SQL connection with Enhanced Dataset Metadata
Hi, 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.
