Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, April 26, 2016 2:45 PM
I built pivots and when I then tried to build charts and set data to automatically referesh it gives me this error: Pivot error: We couldn't get data from the data model. Here's the error we got. Object reference not set to an instance of an object.
I have checked and no issues with headings. Please assist so that I can fix.
All replies (4)
Wednesday, April 27, 2016 6:37 AM | 1 vote
Hi KimLombard,
Which format of files did you use in Excel? .xls or .xlsx?
First please check the file format you're using.
Then the PowerPivot data file is corrupt. This might occurs because of a lot of reasons, for example, power failure, or the workbook isn't closed correctly, etc.
Please try to update or refresh the data source in Excel.
You can also try toclear the existing temp file, which by default is located at:
C:\Users\username>\AppData\Local\Temp
Delete the folder named Vertipaq (or the name started with Vertipaq_)
If your issue still exists, did you mind provide the whole error message about your problem?
Regards,
Emi Zhang
TechNet Community Support
Please mark the reply as an answer if you find it is helpful.
If you have feedback for TechNet Support, contact [email protected].
Monday, May 9, 2016 7:01 AM
Hello Emi. I am using an xlsx format. I am having lost of problems with Pivots since upgrading to 2016. Seems to crash a lot and close and then attempt to reopen the file. I did do an update and that seemed to sort out the problem above. Seems that the 2016 version is more unstable than 2013. Often when Excel closes unexpectatly, the pivots get corrupted. So then I have to rebuild from scratch which is time consuming and irritating. But hopefully MS will sort out and it will become more stable. Seems from comments and threads that I am not the only one experiencing these instability issues.
Friday, August 4, 2017 11:05 AM
delete the folder fix my problem, thanks
Sunday, May 26, 2019 2:37 PM
Hi I have error with power pivot. I tried above steps but could not resolve. Also reinstalled. installed Office-2016. As detailed below:
OS-Windows-7+Office-2016-both 64 bits
1- 1- Power Pivot- when we try to add “Table” to “ Add to data model” as show below:
============================
Error Message:
============================
Exception from HRESULT: 0x800A03EC
============================
Call Stack:
============================
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at Microsoft.Office.PowerPivot.ExcelAddIn.ExcelInterOpUtil.CreateLinkedTable(Workbook workbook)
at Microsoft.Office.PowerPivot.ExcelAddIn.ExcelObjectModelSafeAccessLayer.CreateLinkedTable()
at Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.CreateLinkedTable()
2- In power query- error occurs when we try to save and load and tick the option-“ Add this data to data model
============================
Error Message:
============================
We couldn't get data from the Data Model. Here's the error message we got:
The following error occurred while opening the file '\?\C:\Users\mu58683\AppData\Local\Temp\VertiPaq_C61D4F5676144DEE91CB\808e6176-a1c9-4ef6-b174-6b727c554951.0.db\Table1.1.dim.xml': The requested operation cannot be performed on a file with a user-mapped section open. .
============================
Call Stack:
============================
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at Microsoft.Office.PowerPivot.ExcelAddIn.ExcelInterOpUtil.CreateLinkedTable(Workbook workbook)
at Microsoft.Office.PowerPivot.ExcelAddIn.ExcelObjectModelSafeAccessLayer.CreateLinkedTable()
at Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.CreateLinkedTable()