Forum Discussion

Bis's avatar
Bis
Frequent Visitor
9 years ago

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

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

2 Replies

  • Bis's avatar
    Bis
    Frequent Visitor
    9 years ago

    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

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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