Forum Discussion
Live Connection with multiple data source
Hi All,
Please help me, how can i connection Live connection with Multiple different(SQL & SAP) data source.
When i connect with one data source live connection and then try to connect another "Direct Query" option can't be selected.
Hi Anonymous ,
When you connect to a data source with live connection mode, you cannot connect to other data sources. You can only connect to a single data source in each report when you connect to a data source with live connection mode. You can check the following link for more details.
Power BI – Live connection vs. Import, comparison and limitations
Live Connection; When Power BI comes Hybrid
If you want to be able to connect to other data sources while using live connection mode, you can try the methods mentioned in the official documentation below.using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Best Regards
2 Replies
Hi Anonymous ,
When you connect to a data source with live connection mode, you cannot connect to other data sources. You can only connect to a single data source in each report when you connect to a data source with live connection mode. You can check the following link for more details.
Power BI – Live connection vs. Import, comparison and limitations
Live Connection; When Power BI comes Hybrid
If you want to be able to connect to other data sources while using live connection mode, you can try the methods mentioned in the official documentation below.using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Best Regards
Anonymous , could you perhaps confirm if there has been any changes or if with live connection mode, you still cannot connect to other data sources. I'm trying to get confirmation that currently with live connection mode, you cannot connect to other data sources. Thus remains the same as per yur post from 2022, it still not possible.
