Automatic schedule to refresh PowerBI data and upload pibx file to the web

[runnerpaul]

Hi,

I have PowerBidesktop and the PowerBI Personal Gateway which I use to upload my .pbix file to the PowerBI web.

Is there any way I can create a schedule to refresh the data each morning then upload the file automatically?

Cheers

Paul

[Anonymous]

Hi Paul,

Personal Gateway is not used to publish your Pbix file, but only to refresh data between Power Bi Services (this is where you've published your reports) and your On-prem data source.

If you want to schedule your refresh, just go, in Power BI Service on the dataset you've published (it is automaticaly published with your .pbix file), click on the ... button and choose "Schedule Refresh". You can schedule daily or weekly refresh and the time period for daily refresh.

NB : If you have to refresh your data from PowerBI desktop (for example because you use files to import data), you'll have to do it manually, you cannot use Personal Gateway

Hope it's help.

Sebastien

[ashishrj · Accepted solution]

@runnerpaul You can achieve the same using Power BI Personal Gateway. There is no need to upload the file once refresh. Dashboard/Report will automatically get refresh for latest data from the source as long as the Personal Gateway is online.

[runnerpaul]

@ashishrj am I correct in thinking this is a manual process? I'd like to automate this if possible.

[KHorseman]

It is automated. There is no re-uploading after you publish your .pbix the first time (unless you decide to make major changes and replace it for some reason). The gateway manages the automated refresh of the data according to whatever schedule you give the dataset.