Forum Discussion
gvg
Post Prodigy
Post ProdigyPower BI fails to connect to SQL Server in Direct mode while Power Query does connect and show data
Hi, I have configured a table in Power Query that connects to SQL Server table in Direct mode. I see data extracted in Power Query window. However when I Close & Apply I end up with an error mess...
You cannot change from import mode to direct query. You have to start over.
lbendlin
Super User
Super UserThat should work. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .