Unexpected Error: "See Records" doesn't work for Dec 2017 Power BI Desktop

[HCBC]

Is there any resolution for this?  I copied the details below for reference:

...

Release:

December, 2017

Product Version:

2.53.4954.481 (PBIDesktop) (x64)

JS Error Message:

Cannot read property 'value' of undefined

Error Message:

An error occurred while rendering the report.

Stack Trace:

Microsoft.PowerBI.Client.Windows.JavaScriptException: An error occurred while rendering the report.

TypeError: Cannot read property 'value' of undefined

    at DsrToMatrixConverter.readNode (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:5189:99)

    at DsrToMatrixConverter.readNodeChildren (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:5158:185)

    at DsrToMatrixConverter.readHierarchy (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:5147:37)

    at DsrToMatrixConverter.run (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:5105:234)

    at Object.createMatrix (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:5089:83)

    at ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4429:53

    at logTime (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:1715:20)

    at generateDataView (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4428:57)

    at readDsr (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4385:30)

    at Object.read (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4376:22)

Invocation Stack Trace:

   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Exception exception)

   at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWin32Window activeWindow, WindowsHost windowsHost, FeedbackPackageInfo feedbackPackageInfo, Exception e)

   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()

   at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Delegate.DynamicInvokeImpl(Object[] args)

   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

   at System.Windows.Forms.Control.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

   at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)

   at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()

   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()

   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

   at Microsoft.PowerBI.Client.Program.Main(String[] args)

OS Version:

Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:

4.6.1 or later [Release Number = 394271]

Peak Virtual Memory:

3.86 GB

Private Memory:

404 MB

Peak Working Set:

456 MB

IE Version:

11.0.9600.18860

User ID:

e3369e46-06c2-45af-a9f2-f4272b542503

Workbook Package Info:

1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:

False

Model Default Mode:

DirectQuery

Snapshot Trace Logs:

C:\Users\XXXXXX\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1396340773.zip

Performance Trace Logs:

C:\Users\XXXXXX\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:

PBI_shapeMapVisualEnabled

PBI_EnableReportTheme

PBI_numericSlicerEnabled

PBI_daxTemplatesEnabled

PBI_reportBookmarks

PBI_qnaExplore

Disabled Preview Features:

PBI_SpanishLinguisticsEnabled

CustomConnectors

PBI_AdobeAnalytics

Disabled DirectQuery Options:

PBI_DirectQuery_Unrestricted

Cloud:

GlobalCloud

WER Parameters:

{"AppName":"PBIDesktop","AppVersion":"2.53.4954.481","ModuleName":"ms-pbi://pbi.microsoft.com/minerva/scripts/data.js","Component":"DsrToMatrixConverter","Error":"TypeError","MethodDef":"readNode","ErrorOffset":"5189:99"}

WER Reported:

False

DPI Scale:

100%

Supported Services:

Power BI

....

[v-qiuyu-msft]

Hi @HCBC,

Based on my test in the desktop version 2.53.4954.621, See Records works fine when get data from SQL database. Please try to update the desktop to the latest version as ours then test again. 

Also make sure you didn't hit limitations: https://docs.microsoft.com/en-us/power-bi/desktop-see-data-see-records#limitations

If issue persists, please share more information for us to reproduce the issue, eg: which data source connect to, which visualused to visualize data, etc. 

Best Regards,
Qiuyun Yu 

[HCBC]

Thanks Qiuyun.  I tried the latest version you mentioned but no luck at all.  I found that I replaced the hierachy at "Rows" property of Matrix by a column of my table and it works fine.  I think "Rows" property of Matrix doesn't support hierachy in Dec 2017 version.

[v-qiuyu-msft]

Hi @HCBC,

Did you create this hierarchy in Power BI or the hierarchy from SSAS cube? 

Based on my test with SQL database with DirectQuery in desktop version 2.53.4954.621 64-bit (December 2017), created hierarchy in Power BI does work with See Records in matrix visuals. Would you please share detail information for us to reproduce the issue? 

Best Regards,
Qiuyun Yu 

[HCBC]

Hi Qiuyun,

I created the hierachy in power bi desktop.  Here below the error message prompted.

Also, please see the addtional information for your study:

1. SQL Server Version = Enterprise 64-bit
2. Total records = 4,140,000
3. I converted my power bi file from direct query mode to import mode and the result are same

Hope this can help.

[v-qiuyu-msft]

Hi @HCBC,

I can reproduce the issue now. Already reported it internally: CRI 55206359. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @HCBC,

The fix will be released on March 5. 

Best Regards,
Qiuyun Yu