Forum Discussion
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:
- Visuals
- Columns added to existing tables with exactly the same dimension
- 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.
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
1 Reply
- v-danhe-msftMicrosoft Employee
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