Hello,
I spent a lot of time trying to hunt this down to no avail, if someone happens to know a link to the answer it would also be appreciated.
I am interested in finding a way to build an R script into a dashboard for modeling and projections. There are 2 ways that I can do this that I'm aware of -
1. R script is built first, then power bi digests the data and visualizes it. This is very nice to standardize the visualizations and has the neat mouse-over thing going for it, but it does not allow for active slicing (depending on what I am looking to do, more on that below).
2. Use Power BI to call the data first, then add in an R visualization widget. This is nice since the slicers are actively changing the underlying data set, so I can produce a single dashboard for a single idea, and anyone can slice the underlying data to get an answer. However, this only produces an R(really, just ggplot2 since it can be made not-awful looking) visualization. This causes some complexity in maintaining and developing a standard visualization process, and omits some abilities of Power BI (like mouse-over).
I would like to combine the two, which means calling the cube with power bi, then manipulating the data using R in the advanced editor, then outputting a table that power bi can perform visualizations on. I want to do this because I cannot just aggregate the results of indivudal slices for many situations.
This is essentially a single step that I'm not grasping, which is -
How do I call the data that is already in power bi using R within the power query editor? If it matters, the output data is currently "XYZ" and the final step is a cube.transform(). Thanks!
