Forum Discussion

gbottazzi's avatar
gbottazzi
New Member
9 years ago

Fetch all data from dataset in Custom Visual

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

 

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    9 years ago
    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.
    • gbottazzi's avatar
      gbottazzi
      New Member
      9 years ago

      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