Shows only some records when I use R visual

[Anonymous]

I used R visual in my report to show records in table format.

for that, I used 'gridExtra' package.

After Run R script, it shows only 6 records.The actual count is 830.There is no Duplicate Record.

What should I do to show all records?

Thanks,

Pankil

[v-viig]

Looks like you should turn on "Don't summarize" for all of data fields.

Please let us know if that works for you.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

[Anonymous]

I already tried for that.but doesn't work for me.

[v-viig]

Could you please share the whole code?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

[Anonymous]

Hello @v-viig

Thanks for your response.

Here is my code for dataset of two fields.

library(gridExtra)
grid.table(head(dataset))

Thanks,

Pankil

[v-chuncz-msft]

@Anonymous,

You'll need to specify argument n.

https://www.rdocumentation.org/packages/utils/versions/3.4.3/topics/head

[Anonymous]

Hello @v-chuncz-msft,

Thanks for useful share.it is helpful to me.

But I think for display, it seems like, row data is propositional to height of visual.

When I export data it will show all data.so I think the issue is different.

Updated Code is:

library(gridExtra)
grid.table(head(dataset,n=10))

I attached a screenshot of my visual.

Thanks,

Pankil

[v-chuncz-msft]

@Anonymous,

If not necessary, the built-in Table visual is enough.