Forum Discussion
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
Hi Griggers ,
Seems to be 1000 lines limit.
You can try to expand this limit by following the steps below.
- downloads sources
- call
npm installin root folder of the project - Change limit in
capabilities.jsonby addingdataReductionAlgorithm(https://docs.microsoft.com/en-us/power-bi/developer/visuals/dataview-mappings#data-reduction-algorithm)
example is here - change the GUID of the visual
- call
npm run packageto create visual package.
if everything is ok you will get package file in dist folder of the project - import the package file into Power BI.
Refer:
https://github.com/microsoft/powerbi-visuals-gantt/issues/199
Best Regards,
Jay
5 Replies
- amitchandak
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?
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.
Hi Griggers ,
Seems to be 1000 lines limit.
You can try to expand this limit by following the steps below.
- downloads sources
- call
npm installin root folder of the project - Change limit in
capabilities.jsonby addingdataReductionAlgorithm(https://docs.microsoft.com/en-us/power-bi/developer/visuals/dataview-mappings#data-reduction-algorithm)
example is here - change the GUID of the visual
- call
npm run packageto create visual package.
if everything is ok you will get package file in dist folder of the project - import the package file into Power BI.
Refer:
https://github.com/microsoft/powerbi-visuals-gantt/issues/199
Best Regards,
Jay
Hi, could you share the modified one? the extended 30000 rows limit package.
I have very limited knowledge using github.
Hi Anonymous,
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?
