Forum Discussion
Power Query using SQL as a data source
Hi Anonymous
As tested, it seems importing data from SQL wouldn't cause this problem,
Maybe you connect to SQL via direct query mode in excel power query.
In this case, please create a sql database role in SQL server side, grant permission of the specific database and tables(you used in power query) to the end users.
When end users open excel, they can sign in with the granted sql database credential.
To enable the end users to refresh the data on their side, please refre to:
Based on my understanding, if the end users have access to the database and tables, they can refresh the data as creator does.
If you use power query in power bi, then you can publish the power bi desktop file to power bi service where you could configure schedule refresh.
https://docs.microsoft.com/en-us/power-bi/refresh-data
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Create a new read-only SQL Database login (DB user) and instruct end-users to choose Database when prompted and then type user / pass.
This step is needed ONLY FIRST TIME when connecting
Hi Anonymous
As tested, it seems importing data from SQL wouldn't cause this problem,
Maybe you connect to SQL via direct query mode in excel power query.
In this case, please create a sql database role in SQL server side, grant permission of the specific database and tables(you used in power query) to the end users.
When end users open excel, they can sign in with the granted sql database credential.
To enable the end users to refresh the data on their side, please refre to:
Based on my understanding, if the end users have access to the database and tables, they can refresh the data as creator does.
If you use power query in power bi, then you can publish the power bi desktop file to power bi service where you could configure schedule refresh.
https://docs.microsoft.com/en-us/power-bi/refresh-data
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft
Thank you for your advice. I will grant those users a read access only for the SQL database. Thanks a lot!