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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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