topic Fetch more data in Developer

Fetch more data

danieleperilli — Sat, 02 Jun 2018 16:30:43 GMT

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

Re: Fetch more data

v-viig — Mon, 04 Jun 2018 13:42:22 GMT

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Fetch more data

danieleperilli — Mon, 04 Jun 2018 13:43:38 GMT

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

Re: Fetch more data

v-viig — Mon, 04 Jun 2018 13:50:39 GMT

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Fetch more data

danieleperilli — Mon, 04 Jun 2018 13:52:40 GMT

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?

Re: Fetch more data

v-viig — Mon, 04 Jun 2018 13:56:00 GMT

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Fetch more data

danieleperilli — Mon, 04 Jun 2018 14:01:39 GMT

Thanks!

Re: Fetch more data

v-viig — Mon, 04 Jun 2018 14:27:48 GMT

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

Re: Fetch more data

v-viig — Mon, 04 Jun 2018 14:34:48 GMT

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

Re: Fetch more data

danieleperilli — Mon, 04 Jun 2018 15:39:20 GMT

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.

Re: Fetch more data

danieleperilli — Fri, 22 Jun 2018 15:45:36 GMT

@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?

Re: Fetch more data

v-viig — Mon, 25 Jun 2018 08:23:29 GMT

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com