r script to connect multiple database as source in power bi desktop

[Bis]

Hi,

I need to connect to multiple datasource by direct query using R script. This is the requirement.

Can any one help me on this asap ???

Thanks

[v-jiascu-msft]

Hi @Bis,

If you want to connect to multiple data sources by direct query, I afraid this isn't supported by now. Reference: powerbi-desktop-use-directquery.

>>>All tables must come from a single database.

How to run R scripts in Power BI Desktop, please reference this document: powerbi-desktop-r-scripts. Due to the R packages that supported in the Power BI Service are limited, it's a good idea to choose proper packages at the beginning.

Best Regards!

Dale

[Bis]

Hi,

Can any one help me in R script for multiple database connection in power Bi desktop?

Please provide any suggestion/url by which i can do this work..

Thanks