Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jesse_james
Helper I
Helper I

Power BI gateway personal mode to refresh Azure SQL DB data source? is it possible?

Hi, my company requires gateway to refresh Power BI report connected to Azure SQL DB.
I cannot use standard mode gateway so I would like to try with personal mode.
however gateway do not show in report settings. Is it possible to use PBI gateway (personal mode) to configure this refresh? (the same gateway is working properly with local Excel files) 

5 REPLIES 5
ibarrau
Super User
Super User

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.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

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.

You do understand that even if this is possible or not you are downloading data from azure to local and uploading again to power bi instead of just connecting your credentials in Power Bi directly to Azure SQL DB, don't you?
I would strongly recommend to just enter the credentials in the schedule refresh configuration of the report and try to connect without the gateway. Otherwise you might need an Azure VM to install a personal gateway to be the bridge with between DB and Power Bi because if you have it locally is way too overkill.

Regards,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

yes I am aware of it but no gateway option is blocked by DB firewalls policy.

I don't understand what you mean with the last sentence. Be sure that the Azure SQL DB Firewall accepts azure services or microsoft ip list if you want to connect. You should also add the VM public ip.
The answer would be Yes. But pay attention, you can only configure a Personal Gateway to connect Azure SQL DB if you are Importing Data. You can't use direct query with personal option. 

Regards,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors