Forum Discussion
PowerPivot to Power BI
I've been using PowerPivot for a few years and I'm just getting into Power BI, specifically desktop. I am also running on Excel 2016. I am in the middle of recreating my models and importing them int...
konstantinos
Memorable Member
Memorable MemberI can suggest two options.
1. Create the reports on the PowerBI desktop and then publish to PowerBI - and every data model change and report should be in PowerBI desktop so when you upload you get the latest version.
2. Store the data model ( either PowerBI desktop or Excel ) in Onedrive for business and then create the reports in PowerBI. OneDrive refreshes every one hour so you will have the modified data model updated and no changes in the reports.
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-excel-file-onedrive/
3. There is no link between PowerBI Desktop and excel so changes update to each other. One time import only from Excel to PBI.