Forum Discussion
Using BI Desktop with Excel File in OneDrive for Business
We have an Excel file that has a data model derived from a Microsoft Access DB. The Excel file and subsequent data model is updated locally and then synced to OneDrive for Business. We then use the...
I think I understand that, but if I start in the Power BI Desktop designer and then publish to the service, then I will always result in a data source that is considered on-prem. Our University doesn't currently provide a way for our deaprtment to pay for a pro account, so I was hoping I could still use the desktop designer with a source in OneDrive for Business. I'll keep trying.
Here is an article describing how to do it https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-desktop-file-onedrive/