Forum Discussion
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
- BisFrequent Visitor
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
Microsoft Employee
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