Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Griggers
Frequent Visitor

Gantt Chart 2.2.3 Data Issue

Hi,

Could someone tell me if there is a limit on the amout of data that this chart can load ?

Im only seeing very limited data in the chart, but when I turn the chart into a table I can see all the records that I expect.

 

Thanks

Mark

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @Griggers ,

 

Seems to be 1000 lines limit.

You can try to expand this limit by following the steps below.

  1. downloads sources
  2. call npm install in root folder of the project
  3. Change limit in capabilities.json by adding dataReductionAlgorithm (https://docs.microsoft.com/en-us/power-bi/developer/visuals/dataview-mappings#data-reduction-algorit...)
    example is here
  4. change the GUID of the visual
  5. call npm run package to create visual package.
    if everything is ok you will get package file in dist folder of the project
  6. import the package file into Power BI.

Refer:

https://github.com/microsoft/powerbi-visuals-gantt/issues/199 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

5 REPLIES 5
v-jayw-msft
Community Support
Community Support

Hi @Griggers ,

 

Seems to be 1000 lines limit.

You can try to expand this limit by following the steps below.

  1. downloads sources
  2. call npm install in root folder of the project
  3. Change limit in capabilities.json by adding dataReductionAlgorithm (https://docs.microsoft.com/en-us/power-bi/developer/visuals/dataview-mappings#data-reduction-algorit...)
    example is here
  4. change the GUID of the visual
  5. call npm run package to create visual package.
    if everything is ok you will get package file in dist folder of the project
  6. import the package file into Power BI.

Refer:

https://github.com/microsoft/powerbi-visuals-gantt/issues/199 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Hi @v-jayw-msft,

 

I've tried following your instructions, however I'm stuck with the install returning several vulnerabilities and the run package failing with errors. I've tried both to "audit fix" and "audit fix --force" but still I'm unable to repackage the .pbiviz with the updated dataReductionAlgorithm.

 

Would you be able to try on your end and share the resulting .pbiviz file?

Hi, could you share the modified one? the extended 30000 rows limit package.

I have very limited knowledge using github.

Griggers
Frequent Visitor

If I show the data in a table, I get 3,567 Rows and 7 Columns of data.

Im not seeing any error message or message icon.

 

amitchandak
Super User
Super User

@Griggers , Usually there is limit from 2500 data points to 30000, depending on visual. Visual start shwoing an icon for that. Are you seeing some messgae icon?

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.