topic Re: Fetch all data from dataset in Custom Visual in Developer

Fetch all data from dataset in Custom Visual

gbottazzi — Thu, 08 Sep 2016 08:17:16 GMT

Hi,

I'm developing a custom visual and I need to load all records (rows and columns) that are in my dataSet.

My dataSet has 100.000 records and now the max numer of record in options.dataViews[0].table.rows is 30.000.

I would load the data with a sequence of requests with shifting start-point: i.e. from 0 to 500, 501 to 1000 and so on...

A similar behaviour is now present in Table Visual: when the user scroll down, next dataset is loaded.

Can someone help me?

Thanks

Giacomo

Re: Fetch all data from dataset in Custom Visual

v-chuncz-msft — Sun, 11 Sep 2016 17:11:45 GMT

@gbottazzi,

As slicers can narrow the portion of the dataset shown in the other visualizations on the page, I wonder if it is possible to use a slicer to get around the limitation.

Re: Fetch all data from dataset in Custom Visual

gbottazzi — Mon, 12 Sep 2016 15:16:55 GMT

Hi,

slicer.ts is a good example but there is a problem: some object used in that example (like IVisualHostServices) are not exposed in the module created by pbiviz ( powerbi.extensibility.visual).

If I define my custom visual in the same module of slicer.ts than it not compile (i.e. it doesn't know IVisual).

There is a way to use that object from my module?

Thanks

Giacomo