Forum Discussion

Rich_P_G's avatar
Rich_P_G
Icon for Helper I rankHelper I
10 years ago

PowerBI Desktop, Gateways and Measure connectivity?

Hi Guys,   Im after a bit of advice before I go further with this one. I have authored a report in Desktop and shared into a dashboard in the online Service. Within the report I successfully connec...
Rich_P_G's avatar
Rich_P_G
Icon for Helper I rankHelper I
10 years ago

ankitpatira Thanks. The reports I am authorting on desktop are being published to the Service for use in dashboards that others in my team can access.

 

 

I want to be able to have reports authored on my machine in Desktop with calculated measures, connecting to data in sql server. These reports are then published to the Service to drive tiles in dashboards. 

 

What im trying to understand is whether I can have the gateway running on one machine, and use another machine to author the reports and measures in PowerBi desktop?

 

Ideally, all members of my team would author reports in Desktop, connecting to data through the same on premise gateway. They would then share their reports into a collaborative workspace on the service so that we could add to existing dashboards.

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Rich_P_G

What im trying to understand is whether I can have the gateway running on one machine, and use another machine to author the reports and measures in PowerBi desktop? 

Yes, you can. The gateway just acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI Service(not Power BI Desktop).  Power BI Desktop can connect to the data source itself without the gateway.

 

Reference:

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/

 

Regards