cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
masvillatema23
Frequent Visitor

R visuals in Power BI Desktop has a few limitations

Hi guys,

 

Supposedly I am about to analyze the sales distribution for an entire year which have 800,000 observations (approx.). As i was reading R-Scripts Data Limitations that R-visuals has data size limitations shown below, Let's say i want to look at the relationship of their shipment and sales using R-scripts integrated with Power BI, and also about using the geocodes map for visualizations, I only get 26,000(approx.) bubbles but  I have at most 500,000 unique latitude and longitude, do you have any suggestions regarding this matter?

 

R visuals in Power BI Desktop has a few limitations:

  • Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.

Thanks in Advance,

 

Mark

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: R visuals in Power BI Desktop has a few limitations

@masvillatema23

 

According to the official document about Power BI Map visualization, there is no such limit. I think you can try with it instead of the R visual.

 

Best Regards,
Herbert

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

Re: R visuals in Power BI Desktop has a few limitations

@masvillatema23

 

Since there are some limitations for the R visual, you can try with other built-in visuals (e.g. map visuals) according to your data in Power BI Desktop.

 

Best Regards,
Herbert

masvillatema23
Frequent Visitor

Re: R visuals in Power BI Desktop has a few limitations

@v-haibl-msft

 

Hi,

 

 Sorry I think I mislead you on the issue about map visualizations. I used the built in functions of POWER BI to visualize my data using bubble map, But it only plots 26,000 geocodes out of 500,000 unique geocodes. does Powe BI map visualization has limits too in regards to geocodes?

 

Thanks,

 

Mark

 

 

Microsoft
Microsoft

Re: R visuals in Power BI Desktop has a few limitations

@masvillatema23

 

According to the official document about Power BI Map visualization, there is no such limit. I think you can try with it instead of the R visual.

 

Best Regards,
Herbert

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors