Forum Discussion
Post ProdigyPower BI fails to connect to SQL Server in Direct mode while Power Query does connect and show data
You cannot change from import mode to direct query. You have to start over.
Post ProdigyAnonymous Thank for your tips. However I failed to find role allowing to perform queries only. Should Write permissions be granted in order to be able to use Direct queries? On the other hand is role db_datareader not sufficient to use Direct queries in Power BI?
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.
