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

[ZoltanBojtar]

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!

[Greg_Deckler]

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]

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]

Hi @ZoltanBojtar ,

Have you solved your problem?

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

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