Forum Discussion
gvialetto_kv
5 years agoRegular Visitor
Execute R script in custom installation from PowerBI service
Dear all, I am developing a PowerBI report based on data that are calculated by an R script. This script is executed esternally and write the results to a SQL database. Then PowerBI service read ...
lbendlin
5 years agoSuper User
Depends on what license you have for Microsoft Power Automate. In Power BI you can have a Power Automate button that could then trigger a flow to run the script and to refresh the dataset.
It would still not mean that the report user would see the result immediately - they would have to manually refresh their browser - after the (uncertain) period of time that the script takes to run, and the dataset refreshes.
All in all not a satisfying user experience.