Hi all,
I have this issue for quite some times and it's really annoying me to the core.
I have developed a few Excel based reports by using the following approach:
1) PowerQuery to load the data into PowerPivot model.
2) Build some pivot table and chart reports.
3) Upload to OneDrive for Business
4) From PowerBI, Connect, Manage, and View Excel in PowerBI.
5) User view reports in PowerBI service
The problem:
User requested to include some additional field from the database.
1) I go back to the Excel report, open up PowerQuery and add in the new fields.
2) Close and Load the new field into the PowerPivot model.
3) Refresh all the data connection from Excel and everything tested successfully without error.
4) Save and upload the Excel file report to OneDrive. I replaced the existing Excel file in the OneDrive folder.
5) Open from Excel Online, click refresh All Data Connection.
6) Refresh failed with error stating the query failed due to the new field.
7) Tried deleting everything from OneDrive and reupload and recreate from PowerBI service still fail.
The only way it will refresh successfully is when from PowerQuery, I create a new query with the new field and delete the old one, and reupload. The problem is, all my measures in PowerPivot would be gone. I even need to recreate the entire report.
So all the expert here, what actually happens? How can i force the uploaded data model in PowerBI service to update the latest changes without failing it?
Thanks in advance!
