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...
This is what I understand - others may know better.
Power BI service needs a source. Your source is an Excel file. Once you go down that path, you can only edit the PBI part in the service. The other approach is to start with PBI Desktop as the source. As you mention, this gives a lot more flexibility.
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.