Get data from RDATA file

[LY18]

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

[Syndicate_Admin]

I have the exact same problem

[Syndicate_Admin]

But that's right, with load() it is perfectly achieved. Thank you

[Greg_Deckler]

Can't you just load it in your r script step?
https://www.rdocumentation.org/packages/miceadds/versions/3.8-9/topics/load.Rdata

[Mariusz]

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