Forum Discussion
Correspondence map
Hello,
I am still relatively new to PowerBI. I just wanted to know what would be the best way about creating a correspondence map in PowerBI? Is there an existing bit of code or addon I can use? If not, is it easiest to create with an R visualisation I take it? Then as well - are there limitations or issues with R visualisations after you want to publish on the server?
Thanks!
Hi GreyMerchant ,
About publishing to web:
R scripts security
R visuals are created from R scripts, which could potentially contain code with security or privacy risks.
These risks mainly exist in the authoring phase when the script author run the script on their own computer.
The Power BI service applies a sandbox technology to protect users and the service from security risks.
This sandbox approach imposes some restrictions on the R scripts running in the Power BI service, such as accessing the Internet, or accessing to other resources that are not required to create the R visual.
As document 'r security' mentioned, current it block all requests such as 'accessing the Internet', or 'accessing to other resources' that are 'not required' to create the R visual. So R visuals do not display when using Publish to web.
About R scripts in power query editor:
You should use R packages which are supported in power bi, please refer this document: R packages that are supported in Power BI
Other limitations are simliar with power bi service, you can refer my previous post.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if this can help
https://www.mssqltips.com/sqlservertip/5197/correlation-analysis-using-correlation-plot-in-power-bi-desktop/
Appreciate your Kudos.Thanks for your response. What I am hoping to mimic is exactly this in PowerBI: https://www.displayr.com/how-correspondence-analysis-works/
Hi GreyMerchant ,
- Currently in power bi app source, there seems no correspondence map visual in it so it is a goog way to use R script visual to create custom visuals as your need.
- About R visuals, here are some limitaions on power bi service:
R visuals support is limited to the packages identified in Learn which R packages are supported. There currently is no support for custom packages.
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. Additionally, the input data has a limit of 250 MB.
Calculation time limitation – if an R visual calculation exceeds 60 seconds the script times out, resulting in an error.
R visuals are refreshed upon data updates, filtering, and highlighting. However, the image itself is not interactive and does not support tool tips.
R visuals respond to highlighting other visuals, but you cannot click on elements in the R visual in order to cross filter other elements.
R visuals are currently not supported for the Time data type. Please use Date/Time instead.
R visuals do not display when using Publish to web.
R visuals do not support renaming input columns. Columns will be referred to by their original name during script execution.
R visuals currently do not print with dashboard and reports printing
R visuals are currently not supported in the DirectQuery mode of Analysis Services
You can refer this document about creating and using R visuals in power bi.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
v-yingjlthanks for the reply! Can you just let me know more about this point:
R visuals do not display when using Publish to web.
Then in addition - the Power Query Editor - what are the limitations here in terms of using R?
Hi GreyMerchant ,
About publishing to web:
R scripts security
R visuals are created from R scripts, which could potentially contain code with security or privacy risks.
These risks mainly exist in the authoring phase when the script author run the script on their own computer.
The Power BI service applies a sandbox technology to protect users and the service from security risks.
This sandbox approach imposes some restrictions on the R scripts running in the Power BI service, such as accessing the Internet, or accessing to other resources that are not required to create the R visual.
As document 'r security' mentioned, current it block all requests such as 'accessing the Internet', or 'accessing to other resources' that are 'not required' to create the R visual. So R visuals do not display when using Publish to web.
About R scripts in power query editor:
You should use R packages which are supported in power bi, please refer this document: R packages that are supported in Power BI
Other limitations are simliar with power bi service, you can refer my previous post.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
