Forum Discussion
Get data from RDATA file
Hi,
In our company we have several R scripts automated that generate Rdata files as results.
I would like to use these results as dataset in power BI ...
I couldn't find a way to open Rdata file ???
I can see that i can use R Script but i don't want to re generate the Rdata (very long calculation) ... do you know how to directly read the Rdata file as a table? ... to use it as a dataset in powerbi desktop (and manipulate it in query editor)
thanks in advance for your help
regards
4 Replies
Hi LY18
As explained in the below article you can use load() function
https://bookdown.org/ndphillips/YaRrr/rdata-files.html
Use R in Power Query Editor
https://docs.microsoft.com/en-us/power-bi/desktop-r-in-query-editor
I don't ting that there is a connector to connect directly to rdata file.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn- Can't you just load it in your r script step?
https://www.rdocumentation.org/packages/miceadds/versions/3.8-9/topics/load.Rdata I have the exact same problem
But that's right, with load() it is perfectly achieved. Thank you
