R script to read table in data model

[webportal]

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.

[v-danhe-msft · Accepted solution]

Hi @webportal ,

Each pbix is an as model, you could use AS connector to connet the model you have created in your former data:

https://www.biinsight.com/four-different-ways-to-find-your-power-bi-desktop-local-port-number/

Regards,

Daniel He