Forum Discussion
Using Service Account instead of Individual Account to refresh Data from SQL Server
Hi, I have a report using import option from a sql server. In Power BI Desktop i have used my login to connect to dev environment and imported data. Publish the dev version to Power BI serv...
amitchandak
Super User
Super UserAnonymous , if you are using on-premise SQL server than you need to setup gateway
https://radacad.com/the-power-bi-gateway-all-you-need-to-know
In the case of Azure SQL, you can change the credentials in power Bi service and make it work.
Refer:https://radacad.com/power-bi-get-data-from-azure-sql-database