Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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
@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.
@ashishrj am I correct in thinking this is a manual process? I'd like to automate this if possible.
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.
Proud to be a Super User!
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
56 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |