Please help: On-Premise and Cloud data

[Anonymous]

Hi all,

I have a big problem here..

I have created reports with on-premise data (web) and excel sheets from cloud (sharepoint) folder. Right now, the PBIX file is hosted in SharePoint. So the problem is, how can the PBIX file be refreshed automatically since there are also on-premise data?

If I need on-premise gateway, how will it work? I can't have the PBIX and on-premise gateway hosted on MY computer.

What I was thinking is:

1) Have a Virtual Machine

2) Host the PBIX file and the on-premise gateway on the virtual machine. (It's for a big organization, is it required to use the one they have today or something?

3) The reports in Power BI Service will be refresh automatically. 

Please share your thoughts on this.

Thanks!

[healthEteam · Accepted solution]

Kind of confused by the "on-premise data (web)" phrase.

Is it truly data that is sitting on a physical machine in an office, which to me would be on prem - or is it a web datasource?

If it is truly an on premise datasource then you would need to connect to that datasource in your Power Bi Desktop file, build out your model, publish it to the power bi service.  Then go into your power bi service, download the gateway and place it on a machine that is in the network of the machine that houses the data (doesnt have to be on the server itself).  Configure the data gateway (making SURE that the resource you are pointing to is the exact same name as you used in your power bi desktop file).

When you say "host the pbix file" - do you mean the pc that you use power bi desktop on?  That can be any pc as long as you have access to the datasource.  Once you publish it to your tenant space (Power Bi Service) and the gateway is configured - Power Bi Desktop is out of the picture until you want to change/update your model and republish.

Hope that helps.

[healthEteam · Accepted solution]

Kind of confused by the "on-premise data (web)" phrase.

Is it truly data that is sitting on a physical machine in an office, which to me would be on prem - or is it a web datasource?

If it is truly an on premise datasource then you would need to connect to that datasource in your Power Bi Desktop file, build out your model, publish it to the power bi service.  Then go into your power bi service, download the gateway and place it on a machine that is in the network of the machine that houses the data (doesnt have to be on the server itself).  Configure the data gateway (making SURE that the resource you are pointing to is the exact same name as you used in your power bi desktop file).

When you say "host the pbix file" - do you mean the pc that you use power bi desktop on?  That can be any pc as long as you have access to the datasource.  Once you publish it to your tenant space (Power Bi Service) and the gateway is configured - Power Bi Desktop is out of the picture until you want to change/update your model and republish.

Hope that helps.

[Anonymous]

Hi @healthEteam

Thank you!

The data I am using is coming from an API, and I'm using the "web" connector in Power BI Desktop.

Now, I have created Power BI reports and published it to Power Bi Service. The PBIX file is in a SharePoint folder. 

We want to have a scheduled refresh on these reports, and since "web" connector is an onpremise source source https://docs.microsoft.com/nb-no/power-bi/service-gateway-onprem#list-of-available-data-source-types

we need to install a gateway. 

So you are suggesting that I can:

1. install a gateway on a machine that is in the network of the machine that houses the data 

2. or I can have it on a virtual machine, if the company have one?

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Have you solved your problem?

If you have solved, 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.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous,

Actually, we'd better not install a gateway on a computer, such a laptop, that may be turned off, asleep, or not connected to the Internet because the gateway can't run under any of those circumstances.

You 'd better install the data gateway on the server which won't be turned off and always in the internet.

More details about install on-premise gateway, you could have a good look at this document.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[v-piga-msft]

Hi @Anonymous,

The reply of  Greg_Deckler should be useful.

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.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[Greg_Deckler]

So, typically you would publish the PBIX to the service and install an on-premises gateway (enterprise or personal). This would get data refresh working. Then you would create an embed code for SharePoint for Power BI Modern webpart.

[Anonymous]

@Greg_Deckler, @v-piga-msft

I know, but the problem is:

1) Where can I host the PBIX and where should I install an on-premise gateway? 

Can I have a virtual machine, and have the gateway install there with the Power BI file?