Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 "Dir...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Axiomite
    Icon for Resolver II rankResolver II
    2 years ago

    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.