create new table using R

[andre_kauber]

Hello,

can I actually use an R script to create a new table with summarized metrics of an existing table, or do I need to create a calculated table with DAX? I assumed that R could be used to create new tables, but when I tried, I realized that any operation run on an existing table essentially replaces it, correct?

[Greg_Deckler]

I would use DAX and probably use SUMMARIZE. In theory, you could copy your query for your table, add an R script step and end up with a summarized table. Is there a reason you need R to summarize a table?

[andre_kauber]

Thank you for your reply. I need R because I know it, but I don't know DAX yet 🙂

So, you're saying that it is possible to use R to generate a new table? As explained, when I run the R script on an existing Power BI table, the result overwrites my table instead of creating a new one..

[Greg_Deckler]

Well, if you know R, DAX is an utter cake walk. So, when you say "run the R script on an existing Power BI table", how, specifically, are you doing that?

[andre_kauber]

I loaded the table from an excel file in Power BI, then edit query, transform, run R script. I pasted my working code from R and run it. The result overwrote the existing table.

[Greg_Deckler · Accepted solution]

Right. Copy this query in Query Editor (right-click, copy and then paste) Rename this new query to something else, "Summarized". Then, in the original query, remove your R script step. Presto, 2 tables.

[Anonymous]

Hello

Sorry, I do not get your answer. I have three datasets (uploaded from excel) and want to do data management using R, in particular using rbind function in order to create a unique dataset where I will do my dashboard.

I have followed exactly this post : https://stackoverflow.com/questions/44897796/operations-on-multiple-tables-datasets-with-edit-querie...

and my rbind works except that my dataset rbind overwrites my first dataset and i would like to have another one.

When you said "rename this new query" is it my first data frame? 

Thanks,

Mélissa

[UTexas80]

Hi - I have looked through all the posts but not been able to find the query solution. If it is not too much trouble can you please re-post it?

Thank you.