Forum Discussion

ZoltanBojtar's avatar
ZoltanBojtar
Regular Visitor
7 years ago
Solved

Relay PowerBI Service and onprem gateway to work with data from outside PBI Desktop

Hi All,

 

Is it possible to do data transformation, create measures etc by using onprem gateway to Power BI Service?

It looks like I can only do basic report editing at the online surface, but cannot do the above like in the Desktop version.

I need to figure out how the customer can give me access to his data "real time" without exposing it to the public internet, or using VPN. Gateway looks promising, but only for refresh, it looks like. Or do you know if it is possible to transfer the data with it to the Service and then somehow work with it from an external, remote Desktop? Thanks!

Need Help
Tips and Tricks
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi ZoltanBojtar ,

    With dataflows, we can create a collection of data from various sources, clean the data, transform it, and then load it to Power BI storage. 

    After loading the data source in dataflow, we could transform data like that in power query in Power BI Desktop.

    You could have a reference of this document about Dataflows in Power BI Service.

    Best  Regards,

    Cherry

     

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    So, I'm thinking that perhaps your customer can use a gateway coupled with a dataflow to publish their data to the service. Then perhaps you could dowload or connect live to that model via the Desktop. 

    • ZoltanBojtar's avatar
      ZoltanBojtar
      Regular Visitor
      7 years ago

      Thanks Greg, though I am afraid my experience is not yet there so that I could translate it to practical steps, but I would be happy to learn and find more info about it :)
      In the meantime if you could share a bit more detail on how to "use a gateway coupled with a dataflow to publish their data to the service" can be done, or could share a good resource to read, I would appreciate it.

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        Hi ZoltanBojtar ,

        With dataflows, we can create a collection of data from various sources, clean the data, transform it, and then load it to Power BI storage. 

        After loading the data source in dataflow, we could transform data like that in power query in Power BI Desktop.

        You could have a reference of this document about Dataflows in Power BI Service.

        Best  Regards,

        Cherry