Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
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

@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
v-haibl-msft
Microsoft Employee
Microsoft Employee

@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

@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

 

 

@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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.