Forum Discussion

danthu's avatar
danthu
Helper I
9 years ago

Using PowerBI table as data source for R Script Query

I have an R script that I would like to run on one of my tables in PowerBI and then store the results in a new table. Is this possible? So far I have only been able to do this by first extracting my ...
Need Help
danthu's avatar
danthu
Helper I
9 years ago

Ok, that's a pity that I can't use the data in the Power bi directly. Any specific reason why this is not available?

 

I guess I will have to manually export to a .csv file everytime I want to use the data then. I was hoping this would not be needed.

 

I need the relationships to the other tables in order to be able to recreate the calculated columns. Can I use the relationships inside the query editor?

  • LordDucon's avatar
    LordDucon
    New Member
    3 years ago

    "This is due to the data source supported in Power BI desktop doesn't include the exiting table in current pbix file."


    This is extremely inconvenient. I needed to call an exiting table from M / Power Query to further transform my data and prepare it for reporting, with R scripts and functions I have written.


    Given the inherent limitations of Power Query, it is very cumbersome to use as an ETL environment :

    - it is slow

    - lacks native iteration syntax (have to use recursion, but not "recommended")


    Are you telling me the only way out of this is to bypass M / Power Query entirely and use R for all my data transformations ?