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...
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Rich_P_G You don't need gateway to be able to connect live from power bi desktop to data source on premise. Gateway is only required for power bi service. Gateway should be installed on server that is never turned off and so that reports in your power bi service are able to connect to your data source via gateway. 

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