topic Re: Shows only some records when I use R visual in Developer

Shows only some records when I use R visual

Anonymous — Thu, 28 Dec 2017 06:59:17 GMT

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

Re: Shows only some records when I use R visual

v-viig — Thu, 28 Dec 2017 07:42:58 GMT

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

pbicvsupport@microsoft.com

Re: Shows only some records when I use R visual

Anonymous — Thu, 28 Dec 2017 12:22:10 GMT

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

Re: Shows only some records when I use R visual

v-viig — Fri, 29 Dec 2017 07:47:19 GMT

Could you please share the whole code?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Shows only some records when I use R visual

Anonymous — Fri, 29 Dec 2017 10:52:34 GMT

Hello @v-viig

Thanks for your response.

Here is my code for dataset of two fields.

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

Thanks,

Pankil

Re: Shows only some records when I use R visual

v-chuncz-msft — Tue, 02 Jan 2018 07:55:20 GMT

@Anonymous,

You'll need to specify argument n.

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

Re: Shows only some records when I use R visual

Anonymous — Wed, 03 Jan 2018 12:55:10 GMT

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

Re: Shows only some records when I use R visual

v-chuncz-msft — Thu, 04 Jan 2018 09:50:52 GMT

@Anonymous,

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