Forum Discussion
Power BI gateway personal mode to refresh Azure SQL DB data source? is it possible?
Hi. I would like to ask you some questions first to understand better the situation.
Is Azure SQL DB the only source in the report? why can't you use a standard gateway?
If the Azure SQL DB is the only source then you don't need a gateway to configure the credentials in Power Bi Service under Schedule Refresh options of the report because it's cloud. However if you have local data like excel files and the Azure DB together in one report, you will need the standard gateway to configure the excel sources and check an option lo split cloud and local data.
I hope this make sense.
yes, this is only one source. As I wrote my company policy requires a gateway to refresh Azure SQL DB.
I cannot install standard gateway on this machine due to some other project constraints so I would like to go with personal mode if possible.