Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
marma330
Helper I
Helper I

error using PowerPivot

‎12-14-2020 10:41 PM

I am following a simple example from "Hands-On SQL Server 2019 Analysis Services, Design and query tabular and multi-dimensional models using Microsoft's SQL Server Analysis Services"  by Steven Hughes

 

It's the first step for creating a tabular model, we are prototyping in excel, so we open PowerPivot, I can import all the data and then I get the below error:

 

I am using the standard WWI datasets.

 
 

del.jpg

 

With the below message:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at System.Windows.Forms.DataGridViewCell.GetEditedFormattedValue(Object value, Int32 rowIndex, DataGridViewCellStyle& dataGridViewCellStyle, DataGridViewDataErrorContexts context)
at System.Windows.Forms.DataGridViewCell.PaintWork(Graphics graphics, Rectangle clipBounds, Rectangle cellBounds, Int32 rowIndex, DataGridViewElementStates cellState, DataGridViewCellStyle cellStyle, DataGridViewAdvancedBorderStyle advancedBorderStyle, DataGridViewPaintParts paintParts)
at System.Windows.Forms.DataGridViewRow.PaintCells(Graphics graphics, Rectangle clipBounds, Rectangle rowBounds, Int32 rowIndex, DataGridViewElementStates rowState, Boolean isFirstDisplayedRow, Boolean isLastVisibleRow, DataGridViewPaintParts paintParts)
at System.Windows.Forms.DataGridViewRow.Paint(Graphics graphics, Rectangle clipBounds, Rectangle rowBounds, Int32 rowIndex, DataGridViewElementStates rowState, Boolean isFirstDisplayedRow, Boolean isLastVisibleRow)
at System.Windows.Forms.DataGridView.PaintRows(Graphics g, Rectangle boundingRect, Rectangle clipRect, Boolean singleHorizontalBorderAdded)
at System.Windows.Forms.DataGridView.PaintGrid(Graphics g, Rectangle gridBounds, Rectangle clipRect, Boolean singleVerticalBorderAdded, Boolean singleHorizontalBorderAdded)
at System.Windows.Forms.DataGridView.OnPaint(PaintEventArgs e)
at Microsoft.AnalysisServices.Common.TableWidgetGridControl.OnPaint(PaintEventArgs e)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at Microsoft.AnalysisServices.Common.TableWidgetGridControl.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4250.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
Microsoft.Office.PowerPivot.ExcelAddIn
Assembly Version: 13.0.0.0
Win32 Version: 2015.130.1605.199
CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Office.PowerPivot.ExcelAddIn.dll
----------------------------------------
Microsoft.AnalysisServices.Excel.BackEnd
Assembly Version: 13.0.0.0
Win32 Version: 2015.130.1605.199
CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.BackEnd.DLL
----------------------------------------
Microsoft.Office.Interop.Excel
Assembly Version: 15.0.0.0
Win32 Version: 15.0.4569.1506
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/15.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
----------------------------------------
office
Assembly Version: 15.0.0.0
Win32 Version: 15.0.4613.1000
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/office/15.0.0.0__71e9bce111e9429c/office.dll
----------------------------------------
Microsoft.AnalysisServices.XLHost.Modeler
Assembly Version: 13.0.0.0
Win32 Version: 13.0.1605.199 ((BI_Office_Dev).201007-1845)
CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.XLHost.Modeler.DLL
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.AnalysisServices.Excel.Common.FrontEnd
Assembly Version: 13.0.0.0
Win32 Version: 13.0.1605.199 ((BI_Office_Dev).201007-1845)
CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.Common.FrontEnd.DLL
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Microsoft.AnalysisServices.Common
Assembly Version: 13.0.0.0
Win32 Version: 13.0.1605.199 ((BI_Office_Dev).201007-1845)
CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Common.DLL
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.Excel.Amo.Core
Assembly Version: 13.0.0.0
Win32 Version: 13.0.1605.199 ((BI_Office_Dev).201007-1845)
CodeBase: file:///C:/Program%20Files/Common%20Files/Microsoft%20Shared/OFFICE16/DataModel/Microsoft.Excel.Amo.Core.dll
----------------------------------------
PresentationFramework
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4270.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
WindowsBase
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
PresentationCore
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
System.Xaml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4270.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
----------------------------------------
Microsoft.Data.Recommendation.Client.Picasso
Assembly Version: 13.0.0.0
Win32 Version: 13.0.1605.199 ((BI_Office_Dev).201007-1845)
CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Picasso.DLL
----------------------------------------
Microsoft.Data.Recommendation.Client.Core
Assembly Version: 13.0.0.0
Win32 Version: 2015.130.1605.199
CodeBase: file:///C:/Program%20Files/Microsoft%20Office/Root/Office16/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Core.DLL

 

Labels:
Message 1 of 2
461 Views
0
1 REPLY 1
Icey
Community Support
Community Support

‎12-17-2020 11:50 PM

Hi @marma330 ,

 

Does this happen when connecting to other data sources? Or, does this issue also occur when you import a smaller tabular model?

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Message 2 of 2
443 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All