Forum Discussion

brypie's avatar
brypie
Regular Visitor
9 years ago
Solved

30000 row limit

Hi All,

 

I'm pretty new to Power BI, but I have been asked by a client to investigate the use of the 3rd party "HierarchySlicer" visualization.

That particular visualization has a built-in data record limit of 4000 (by using the dataReductionAlgorithm code).

 

I can tweak the number specified in the code to be a larger number, but no matter how high I set it, I am only ever getting back a maximum of 30,000 records.

The client has more than 30,000 records in the data set they wish to show in the slicer.

 

I also followed a simple tutorial to create a quick slicer visulization of my own, but I'm hitting the exact same 30,000 row limitation.

 

Is this something that can be worked around, or is there an alternative way of getting all the required data to show?

Does the same limitation apply if/when the dashboard is published?

 

Many thanks, and apologies if this is duplicating queries...

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi brypie,

    The limitation of HierarchySlicer also applies when you publish Power BI Desktop file to Power BI Service. HierarchySlicer is a custom visual built by Jan,  regarding to the limitation in HierarchySlicer, you can directly contact the author. In this link, you can send an email to the author by clicking “Contact Author”.

    In addition, it seems you have issues when creating your own custom visual, if so, you can post the question in Power BI Developer forum at http://community.powerbi.com/t5/Developer/bd-p/Developer to get dedicated support.

     

    Thanks,
    Lydia Zhang

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi brypie,

    The limitation of HierarchySlicer also applies when you publish Power BI Desktop file to Power BI Service. HierarchySlicer is a custom visual built by Jan,  regarding to the limitation in HierarchySlicer, you can directly contact the author. In this link, you can send an email to the author by clicking “Contact Author”.

    In addition, it seems you have issues when creating your own custom visual, if so, you can post the question in Power BI Developer forum at http://community.powerbi.com/t5/Developer/bd-p/Developer to get dedicated support.

     

    Thanks,
    Lydia Zhang