March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to 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
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
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
119 | |
88 | |
73 | |
67 | |
49 |
User | Count |
---|---|
199 | |
140 | |
96 | |
77 | |
68 |