Live Connection with multiple data source

[Anonymous]

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.

[v-yiruan-msft · Accepted solution]

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

[Axiomite]

@v-yiruan-msft , 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.