A co-worker in my organization has published a PBI Desktop model to the cloud and shared it with me as well. He then used the "Analyze in Excel" feature which create an Excel file linked to the data model. In the Excel model he created a pivot table, saved the model and sent me the model.
I open the model, I click on Refresh All, and I get the following error "The HTTP server returned the following error: Forbidden, Activity ID: FE0E4AAB-B7DE-4EFA-943B-B8B8F68F3302"
I understand that you cannot share these Excel files to those outside your organization, but I am in the same organization. I've researched this error and a solution is to edit the ODC file, but only he would have the ODC file when he created the file orginally.
Anyone know how I can get this file to work?