Forum Discussion

gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Power 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...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    You cannot change from import mode to direct query. You have to start over.

gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
2 years ago

OK, I have db_datareader enabled. I can connect to my data source in import mode. However when I change it to Direct mode, it does not connect anymore.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You cannot change from import mode to direct query. You have to start over.