Forum Discussion
Power Bi refresh options
Hi,
Hoping someone can help me to see what my options are for creating a scheduled refresh.
This is my current workflow:
Download a excel file from a web page and save it into a folder stored In OneDrive.
Access my Power BI desktop pbix file and press refresh to refresh the data source.
Republish the report to my workspace for other people to view.
What I am trying to do is cut out the part where I have to go into my pbix to refresh.
If this isn’t possible, would recreating my report directly in Power Bi online version (rather than Desktop) solve my problem?
2 Replies
Trebor84 , after you publish report/dataset, you can create a new report in the power bi service itself.
but as of now dataset changes you have to publish using the power bi desktop file only
Hi Trebor84
what's your datasource used in PowerBI? is the excel on OneDrive and you connect it with Web in Desktop? if yes, see
https://5minutebi.com/2018/04/09/power-bi-using-and-refreshing-excel-datasources-with-onedrive/https://community.powerbi.com/t5/Service/OneDrive-Refresh/m-p/1145650
besides, I find links helpful for your reference, see
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrivehttps://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-local-drive
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
if you still have problems, please let me know.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
