Forum Discussion

jaykilleen's avatar
jaykilleen
Icon for Advocate II rankAdvocate II
10 years ago

Dataset built using SQl Server Azure requires Personal Gateway for Refresh

I think I have a gap in my understanding of how PowerBI refreshes it's data. My situation is I have built reports using PowerBI for Desktop and those reports pull data from SQL Server that is hosted ...
Need Help
Tips and Tricks
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

jaykilleen If you have used Azure SQL DB connector and used DirectQuery then when you publish from power bi desktop in powerbi.com it will ask you to enter credentials to validate against that azure sql db. From then on when you hit refresh it will connect straight to azure sql db not on-premise. When setting up your powerbi desktop report which connector did you use ?