Hierarchy Slicer- Deselect all produce "Unexpected Error"

[xaviermiller]

Hi !

With Power BI Desktop of September 2017 and HierarchySlicer, connected to a SSAS database, I have "Unexpected error" when I deselect the selection.

Scenario :

- Insert a Hierarchy Slicer and assign it to a Dimension attribute

- Select an item

- Deselect that item

=> "Unexpected Error"

Feedback Type:
Frown (Error)

Timestamp:
2017-10-12T12:20:15.2936711Z

Local Time:
2017-10-12T14:20:15.2936711+02:00

Product Version:
2.50.4859.502 (PBIDesktop) (x64)

Release:
September 2017

IE Version:
11.608.15063.0

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-GB)

CLR Version:
4.6.2. or later [Release Number = 460798]

Workbook Package Info:
1* - fr-BE, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
411 MB

Private Memory:
310 MB

Peak Virtual Memory:
33.9 GB

JS Error Message:
Script error.

Error Message:
An error occurred while rendering the report.

Stack Trace:
Microsoft.PowerBI.Client.Windows.JavaScriptException: An error occurred while rendering the report.
   at :line 0

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   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)

[xaviermiller]

Single Selection is NOK

Multiple Selection (Single Selectio = OFF) is OK

[v-caliao-msft]

@xaviermiller,

Since HierarchySlicer visual is developed by Jan Pieter Posthuma, please contact him for this issue. You can click the Support in this site to reach him. 

Regards,

Charlie Liao

[xaviermiller]

Hi,

Indeed, there are some issues, like this one: https://github.com/liprec/powerbi-hierarchySlicer/issues/9

Kind regards,

Xavier Miller

[jppp]

The latest version of the HierarchySlicer (v1.1.5) is now available for everyone.
Can you confirm that it fixes this issue?

Thanks, Jan Pieter

[bidgeir]

I get no error if I have a hierarchy in the slicer but if I have only one level I still get the error when deselecting everything. I tried deleting the visual and getting it again from the store and I still have the problem. I tried to add the slicer to a report with imported dataset and then it works fine. It must be something about live connection to SSAS MD.

A workaround is using the Select All option but it messes up our design that is maximising the use of space. Below is the error I get if it helps. By the way the single select issue is still there as well.

Feedback Type:
Frown (Error)

Timestamp:
2017-10-19T15:23:09.4283107Z

Local Time:
2017-10-19T15:23:09.4283107+00:00

Session ID:
e3c1d38a-51a4-4489-af42-5a408a312954

Release:
October 2017

Product Version:
2.51.4885.701 (PBIDesktop) (x64)

JS Error Message:
"Script error."

Error Message:
An error occurred while rendering the report.

Stack Trace:
Microsoft.PowerBI.Client.Windows.JavaScriptException: An error occurred while rendering the report.
at :line:0:

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 10.0.15063.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 460798]

Peak Virtual Memory:
33.7 GB

Private Memory:
320 MB

Peak Working Set:
421 MB

IE Version:
11.608.15063.0

User ID:
ba45012d-48f1-4ad2-a82d-e2708b4b6cae

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

AS Live Connection:
True

Performance Trace Logs:
C:\Users\agunnarsson\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_reportBookmarks

Disabled Preview Features:
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

WER Reported:
True

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

[jppp]

As for as I know it should be related to SSAS MD, but can you try clearing the cache of Power BI Desktop by emptying the directory C:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop?

If that is not helping I will start debuging this scenario.

-JP

[bidgeir]

It worked Jan. The problem is gone. Both the error and the single select problem

Thanks a million. 

[bidgeir]

I still have the problem in the service even after publishing again. Works as expected in Desktop after clearing the cache

[jppp · Accepted solution]

Did you also clear the cache of your browser?

If so, what config are you using, so I can start that investigation (as I cannot reproduce it at this moment, of course)

[bidgeir]

you are indeed a clever guy. I hadn't cleared the cache. After doing that it works.

Thank a lot for your help and patience

[vega]

So, when you select the top element in the hierarchy and deselect the same item, it does not throw an error for you?

[vega]

I can confirm that after clearing the cache and installing the updated visual that I am still receiving errors when selecting and deselecting the topmost item in the hierarchy. 

[bidgeir]

I have updated but still have the issue. My source is a SSAS MD cube. Maybe that could be a part of the issue. 

I will test some more and see if I can figure out why I'm still getting the error

[xaviermiller]

Hi,

It's OK for me 🙂

Thanks for the fix!

Kind regards,

Xavier Miller.

[bidgeir]

I'm having the same problem. Unexpected error when de-selecting the only selected item in Desktop. Unable to de-select the only selected item in the service and single selection only is not working. I think this visual has problems after latest update of Power BI. It's a fantastic visual so I really hope it will be fixed soon.

@jppp