Forum Discussion

Mardin's avatar
Mardin
Advocate IV
9 years ago
Solved

Hierarchy Slicer - Unexpected Error

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?

Need Help
  • jppp's avatar
    jppp
    9 years ago

    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

58 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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

  • davidrmo's avatar
    davidrmo
    New Member
    9 years ago

    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.

    • langer83's avatar
      langer83
      Frequent Visitor
      9 years ago

      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.

  • hqureshi's avatar
    hqureshi
    Regular Visitor
    9 years ago

    Hi

     

    I am facing the same issue. Any help is appreciated.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Also just noticed that there doesn't seem to be a scroll in the slicer.  Hoping that is just on the desktop.  Seems OK in the published views. 

    • jppp's avatar
      jppp
      Continued Contributor
      9 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Great!  Any idea how long that usually takes?

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    This seems to be fixed today.  So much better!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Yesterday this was working well.  When we had the issue last week it was in the desktop, but the published versions were ok. Today the slicer is not working in the published copy.  Anyone else having this issue?

    • jppp's avatar
      jppp
      Continued Contributor
      9 years ago

      I do not have any issues with the online version, but can you specify what is not working?

       

      -JP

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        In published reports the Hierarchy slicer did nothing - none of the visuals on the screen changed.  I took the slicer off all tabs, and replaced it. Seems to be better today.  It was strange because last week when I got the error on the desktop the published reports had no issue.  Oh well... things seem better today!

  • himanshunegi07's avatar
    himanshunegi07
    New Member
    8 years ago

    any idea when this issu going to be fix ?

    Mardin wrote:

    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?

     

    • jppp's avatar
      jppp
      Continued Contributor
      8 years ago

      Hi,

       

      This should be fixed with the current version available in the store.

      Also all the reports that uses the HierarchySlicer are updated to the latest version automatically.

       

      Are you still hitting this error? 

       

      Thanks, Jan Pieter

      • MilqueToast's avatar
        MilqueToast
        Regular Visitor
        8 years ago

        This custom visual is now inexplicably breaking in all of my reports.  It worked fine last week, and not I get an "Unexpected Error", "An error occurred while rendering the report".  The problem can be duplicated by clicking on a parent element and then trying to deselect the parent element.