Forum Discussion
Desktop vs Service and data refresh from source files in OneDrive for Business
I use Power BI desktop to create my reports. I have a Power BI Pro subscription. I have the data gateway running on my server. I store all of my source data in OneDrive for Business (and the PBIX...
jmdh, that is very interesting. I am interested to hear what your testing finds. If you validate this, I think you should provide some feedback to MS about this
Matt, this is what I have observed. In Power BI Service I can connect to OneDrive for Business files and by default refresh hourly (awesome). Using Desktop there is no direct connection like in Service > Get Data > OneDrive for Business (ODfB) so I use the Web connector like the article mentions. This bring the Excel file data in from my ODfB file but not in the same way that the Service does. In the screen shot Item A show Schedule Refresh of the PBI Desktop solution deployed to PBI Service. Refresh requires turning on "Keep your data up to date". The scheduled refreshes show under Scheduled (1) and On Demand refreshes show in the OneDrive tab (2). Item B in the screen shot shows the solution where Get Data in the PBI Service was used to directly connect to a ODfB csv file. It also shows that by default ODfB files are kept up to date hourly. Will PBI Desktop get a native OneDrive connector?