Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to 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)
Single Selection is NOK
Multiple Selection (Single Selectio = OFF) is OK
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
Hi,
Indeed, there are some issues, like this one: https://github.com/liprec/powerbi-hierarchySlicer/issues/9
Kind regards,
Xavier Miller
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
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;
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
It worked Jan. The problem is gone. Both the error and the single select problem
Thanks a million.
I still have the problem in the service even after publishing again. Works as expected in Desktop after clearing the cache
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)
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
So, when you select the top element in the hierarchy and deselect the same item, it does not throw an error for you?
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.
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
Hi,
It's OK for me 🙂
Thanks for the fix!
Kind regards,
Xavier Miller.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |