Forum Discussion
Personal Gateway
Did you install the personal gateway on the machine where SQL server is installed? If yes, you only need to open app.powerbi.com in that machine and use Windows Without Impersonation Mode Authentication. Please also make sure you've signed into the personal gateway with the same user which you used to sign into Power BI Service. At last, you just need to enable scheduled refresh, and set the refresh time.
To make it clear, I recorded a video as below. Hope it helps.
Best Regards,
Herbert
When I select WindowsWithoutImpersonation It doesn't perform scheduled refresh unless I Login to Power BI Service. My Requirement is that, It should perform scheduled refresh even if I m not logged in to the server.
What should I do?
You would want to choose Basic if you are going to use SQL Authentication instead of Windows Authentication.
The scheduled refresh should also happen at the defined time even if you don't sign into Power BI Service. You just need to make sure that the gateway is running on your server.
Best Regards,
Herbert