Forum Discussion
How can I read data from a Power BI Dataset in a Power BI Dataflow or Microsoft Flow?
Most Valuable ProfessionalLoading data from a PBI dataset is indeed not supported, and I doubt if it ever will be.
A dataflow is used for data prep, so ETL. As MS says and you can see in the below picture, dataflows are used to help organizations unify data from disparate sources and prepare it for modeling. So data modelling comes after a dataflow.
Hello KiranKr
There is a trick to write first to a .csv using R script but this is working only in Power BI Desktop (not in Power BI Service unfortunately). When the .csv is available then you can read from Power Automate
Example below: just creating a dummy table
then you create a R Visual, allow R script, add the columns you want to export. From that you will see an editor with some comments. You just paste the 3 lines of R Script below (2 last lines are just to display what is written and also R script cannot end without displaying data)
write.table(dataset,file='C:/ML/test.csv', sep=",", append=F, row.names=F)
library(gridExtra)
gridExtra::grid.table(head(dataset))
you are done