cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ZoltanBojtar Frequent Visitor
Frequent Visitor

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User
Super User

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

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. 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ZoltanBojtar Frequent Visitor
Frequent Visitor

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

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 Smiley Happy
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.

Community Support Team
Community Support Team

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

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

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

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.