Forum Discussion
Scheduled Refresh using alternate Windows Credentials
In the Power Query Editor (in PBI Desktop), when you connect to a SQL Server database you can choose to use Windows authentication instead of SQL Server credentials. You can also choose to provide al...
Hi Anonymous ,
The problem may be that the account connected to SQL is not the same as the power bi service login account.
If you want to log in with alternate credentials, you need to log in to power Bi as the user.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, do you have another solutions as what you mentioned do not solve the issue. I have the exact same problem (using personal mode gateway) and there is not one single proper solution described on the forum regarding this.
How come this option is available in desktop and not in service?