Automatically extract data from SQL and Rstudio to Power BI on daily bases

[Anonymous]

I am working in company where everyone use Power Bi Dashboard in daily work to see numbers. I have been working on prediction in Rstudio, the results are quite well. I want to share results with everyone on Power Bi. So, they have good understanding of results. Once I tried connecting Rstudio with power Bi but didnt work.

Main requirement: automatically extract data  on daily bases
 Extract data from MYSQL
 Import data in Rstudio
 Run prediction
 Extract Output in Power Bi dashboard
 
Any other tool or software suggestion also welcomed

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I have no idea how to connect Rstudio with power Bi, but automatically extract data from SQL to power bi is possible.

you might refer to this official document about refresh :

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial 

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql 

For connecting Rstudio with power Bi, I suggest you raise it to the support team for better advice:

https://powerbi.microsoft.com/en-us/support/