Forum Discussion
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...
You cannot change from import mode to direct query. You have to start over.
Hi gvg
The "write" permission is not necessarily required. db_datareader role is sufficient for direct querying, as it allows read-only access to the data source.
However, if you need to modify the semantic model or administrative privileges, you need the administrator or member role in the workspace where the semantic model resides.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
