Forum Discussion

webportal's avatar
webportal
Impactful Individual
7 years ago
Solved

R script to read table in data model

Is it possible to use "Get data / R script" in Power BI Desktop to read a table already loadad in the data model?

 

I know I can use Power Query / Transform to do this, but the output of the R script must contain the same number of rows of the table, otherwise it will return an error.

 

For example, in this other question I've used an R script to cluster 12.000 customers. It works fine if all we need is to add the cluster number to each customer in a new column of a table, but if we need to further analyse the results, like clusters sizes for example, we should be able to generate another table with 3 rows only (we have 3 clusters) - but that doesn't seem possible to do!

 

Or is it? Can anyone help? It would be really amazing to have an integration of Power BI with R algorithms 

 

I have been reading the documentation and other questions related with R in Power BI but it seems that the only possible outputs are: 

  1. Visuals
  2. Columns added to existing tables with exactly the same dimension
  3. Tables imported from external sources

But R algorithms return all sorts of objects with different sizes and those don't seem to be possible to analyse in Power BI.

 

If anyone has a better idea about how to run R algorithms in Power BI, I'd be thankful.