cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Power BI Gateway Data on Report and/or Dashboard

I am very new at Power BI.  I have setup a Power BI gateway that is connected to an Azure SQL Server.  The connection works fine in my gateway.  I cannot find where I connect a report data source to Power BI gateway.  I only see Get Data options like Get Data -> SQL Server.  I cannot figure out how to user my Power BI gateway as a data source.  I also searched for creating a new data set based on a Power BI Gateway.  

 

I want to give the end user the ability to view data in a table on an Azure database.  The Power BI gateway connection works great.  It is not intuitive to me in the Power BI desktop how to consume this Power BI gateway data connection.  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi @Aluminum ,

 

The data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. The gateway is consume in Power BI Service instead of Power BI Desktop.

 

That is to say that only when you publish your pbix file from Power BI Desktop to Power BI Service,  the users need to view or edit report in Power BI Service, and your dataset contains on premise data source or combines on-premises and cloud data sources at the same time, then the gateway is needed to install for getting further latest data.  See more: On-premises data gateway .

 

In your scenario, if your dataset has only the cloud data source Azure SQL Server ,  gateway is not needed. While if your dataset combines on-premises and cloud data sources at the same time, the gateway is needed, and you might add the connection credential of Azure SQL Server to "Date source settings " in Manage gateway in Power BI Service, note that you also need select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

Then you may use manual refresh or schedule refresh to get updated data, see more: Configure scheduled refresh .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

@Aluminum , Refer , if this can help

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted

I have successfully configured my Power BI gateway to work with my Azure server.  How do I now add the table in Azure to my report from the Power BI gateway connection?  I only see a way to directly get data from the Azure server from the Get Data option. I do not see a way to take advantage of the Gateway connection.  The articles shared so far do not provide any information on how to do that.

Highlighted

Hi @Aluminum ,

 

The data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. The gateway is consume in Power BI Service instead of Power BI Desktop.

 

That is to say that only when you publish your pbix file from Power BI Desktop to Power BI Service,  the users need to view or edit report in Power BI Service, and your dataset contains on premise data source or combines on-premises and cloud data sources at the same time, then the gateway is needed to install for getting further latest data.  See more: On-premises data gateway .

 

In your scenario, if your dataset has only the cloud data source Azure SQL Server ,  gateway is not needed. While if your dataset combines on-premises and cloud data sources at the same time, the gateway is needed, and you might add the connection credential of Azure SQL Server to "Date source settings " in Manage gateway in Power BI Service, note that you also need select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

Then you may use manual refresh or schedule refresh to get updated data, see more: Configure scheduled refresh .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors