Fetch more data

[danieleperilli]

In the latest API (1.12.0) is finally possible to bypass the 30K rows limit by setting the dataReductionAlgorithm to window and by checking the options.operationKind during the update (https://microsoft.github.io/PowerBI-visuals/api/references/fetchmoredata/).

Has anyone managed to make it work? In my project I never receive the VisualDataChangeOperationKind.Append also if I set a very small number in the dataReductionAlgorithm config. I only receive the first VisualDataChangeOperationKind.Create.

Thanks

[danieleperilli]

@v-viiganother question on this topic (sorry ):  the Segment property inside metadata is an empty object, but it would be useful if it contained the number of remaining segments, or just their total number. This way, any custom visual could calculate the progress and the total number of rows. Is it possible?

[v-viig]

Thanks for a great suggestion. We'll consider it.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[v-viig]

Does your data set contain more items than specified in dataReductionAlgorithm?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[danieleperilli]

Yes, I also tried to set the dataReductionAlgorithm count to just 10.

[v-viig]

What data view mapping do you use? Categorical? Table?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[danieleperilli]

I'm using categorical data, but I tried also Table (because you used it in the documentation). Same results for me. 

My dataset doesn't contain measures (only columns), it could be the issue?

[v-viig]

Not sure. I'll check it today and get back.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[danieleperilli]

Thanks!

[v-viig · Accepted solution]

It seems fetchMoreData does not work in Debug Visual.

As a workaround please build a package by using pbiviz package.

Please let us know if that works.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[v-viig]

Meantime, we reported this issue to PBI CV API team to fix it.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[danieleperilli]

By compiling the package I can receive the data updates. Thanks!

I wait for the issue fix in the debug environment, but in the meantime I can go ahead.