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,
Today I opened a .PBIX file where I use the Hierarchy Slicer. The moment after the report was opened in PowerBI Desktop I got this message:
-------
Unexpected Error
An error occured while rendering the report.
"Send a Frown"
-------
After doing some investigation I concluded that the Hierarchy Slicer was the source of this error. If I delete the custom visual I do not get the error. Imediately after I download it again from Office Store (through PowerBI Desktop) and put my dimension column in it I get the error.
This has never been an issue before. Anybody else experience this?
Solved! Go to Solution.
All,
I have submitted a new version for approval that fixes the 'unexpected error' and after approval it will be available asap.
Sorry for the inconvenience.
Thanks, JP
How do you download it? The version on Powerbi.com is still from the 5th of July.
All custom visuals that are available in the Office Store are automatically updated when a new version is available.
BTW the release date in the Office Store is not that reliable as the developer can set it himself during submission.
Thanks for quick feedback! Not sure if I fully understand though since I recently started to use PBI.
I'll put it like this: how do make the unexpected error message to disappear (without changing slicer type obviously)? Should I wait for a new release of PBI desktop? Download the hierarchy slicer again? Do nothing and wait for the hierarchy slicer to "update itself"? Something else?
Will you post an update once this is approved? Almost all of my reports are affected as well. Since we're close to month end, this is causing a lot of problems. Thanks!
Usually two business days (from my experience). But no guarantee.
Thanks a lot Jan! Much appreciated!
While I'm at it can I ask you a quick question: In the 1.0.3.0 you mention ragged hierarchies/empty leafs. I suppose this option will remove the "blank" selections in my ragged hierarchy. Do you have any articles/tutorials on how to format the data to allow this feature? I'm asking since I still see my "blank" boxes no matter if I enable or disable Empty Leafs.
Hi, I have not yet a tutorial or any docs regarding, but its is a good point: I will update it this weekend.
The hierachy levels (columns) that should be ignored need to be formatted as an empty/blank value in the source. IF that is the case, then the option 'Empty Leafs' will not show those level values.
-JP
Hi Jan. Works perfectly here
I just played around with the possibilities and have a bit of feedback. I often work with an organizational hierarchy where ragged hierarchies are very nice to have, but I have the employees in each department in another table and would really like to be able add them to the hierarchy – I am able to do this, but when turning “Empty Leafs” off all employees belonging to an empty leaf are not shown. What I am doing are the following:
Table “Employees”:
Dep num: Name:
1 Jan
2 Martin
2 Anders
Table “Organization”:
Dep num: Org Level 1 Org Level 2
1 Sales
2 Sales EU
Where Dep num is used to link the two.
With “Empty Leafs” turn on this shows as:
Sales – (Blank) – Jan
Sales – EU – Martin
Sales – EU – Andres
With “Empty Leafs” turn off it becomes:
Sales
Sales – EU – Martin
Sales – EU – Andres
It would be really nice if it could remove the blanks but show “Jan”, at the level where he belongs:
Sales – Jan
Sales – EU – Martin
Sales – EU – Andres
Not a deal breaker as I can probably merge the two tables to get a similar behavior, but if it was part of the visual it would be really nice J
Hi, thanks for the feedback.
And this scenario is indeed not supported with the ragged hierarchies option I use, but it is an interesting one.
I will put it on my backlog.
Thanks, JP
Any update on the resolution of this error? We use hierarchy slicers on almost every page of our reports since we report on multiple hierarchies. Making changes in Power BI Desktop is frustrating. Thank you!
Are your users having issues with the hierarchy slicer on published reports? I have one user that it seems to causing issues when he is using it.
Same issue here, since the July version.
I experienced the same issue in the July version but not immediately after the upgrade. I found out about this error after the gateway refresh started failing and narrowed the issue down to the hierarcy slicer. I replaced all the hierarcy slicers with the default slicer to solve the issue. Not ideal but at least the report and gateway work now.
Hi @ALL,
In the version 2.48.4792.721 64-bit (July 2017) of Power BI Desktop, I reproduce the scenario and get the same error message. I have reported it internally.
Best Regards,
Angelia
Same here. Didn't seem to correspond to an update to either Power BI Desktop or the visual, so it's a mystery what caused the error.
Such a useful visual, this is very unfortunate.
Hello,
Same here, you can reproduce the error with the file bellow :
Link to PBIX with error on hierarchy slicer
Hi
I am facing the same issue. Any help is appreciated.
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 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |