Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |