Forum Discussion

danieleperilli's avatar
danieleperilli
Kudo Commander
8 years ago
Solved

Fetch more data

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
 
Need Help
  • v-viig's avatar
    v-viig
    8 years ago

    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

    [email protected]

11 Replies

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

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

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • danieleperilli's avatar
      danieleperilli
      Kudo Commander
      8 years ago

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

      • v-viig's avatar
        v-viig
        Community Champion
        8 years ago

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

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]

  • danieleperilli's avatar
    danieleperilli
    Kudo Commander
    8 years ago

    v-viiganother question on this topic (sorry :smileyhappy:):  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's avatar
      v-viig
      Community Champion
      8 years ago

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

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]