May 29 2020 04:17 AM - edited May 29 2020 06:39 AM
I cannot 'Load to' a Data Model from Power Query. Each time I receive this message: "An issue with the Data Model is preventing Microsoft Excel from Opening this workbook. Try restarting Microsoft Excel"
This error is consistent regardless of whether I use a 2 column 5 row table from Excel or a large table built from an Oracle Database. The error is also is consistent whether I am creating a Connection only or a table.
I am able to separately create a table in Excel and add to the Data Model.
Update: Note: This occurs from a new workbook or an existing.
I have done a full Office Repair twice - result is the same. I have exhausted the expertise in my help desk and a 3rd party Microsoft expert.
Please advise as to what I need to tell my help desk to do in order to allow me to have the functionality I need to 'Load to' a data a model from Power Query.
I am using Microsoft Office 365 Pro Plus , specifically, Excel for Office 365 MSO (16,0.11929.20762) 32 bit. I have the add-in for Power Pivot.