ARCHITECTURE ISSUES: Azure ML Studio, RStudio Server & PowerBI Connection

[Anonymous]

Hi All, 

I'm trying to deploy a PowerBI dashboard with some ML (predictive analytic) capabilities however I am having some architecture challenges (this is the first time I've done this). The logic of everything I have done (and intend to do) is detailed below: 

What I have done: 

1. I have used Azure ML Studio to build and train some models and hosted them in the web environment 

2. I can now recall this trained model in a PowerBI environment

What I would like to do: 

1. Use my access to RStudio Server to connect to a dedicated database, run a query and feed this into the PowerBI environment, thus refreshing the ML models I have hosted from the web environment

Can anyone advise if this is possible / provide some help or guidance in getting it done? 

Many thanks! 

Kindest 

Ashley 

[v-xiaotang]

Hi @Anonymous 

Need some time to find the solution, I'll update if there is any progress.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks, looking forward to it!