Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi everyone,
I would like to add data sources to a power bi dataset but obviously this is not possible.
Is there a trick?
Thank you in advance :
Solved! Go to Solution.
Hi @LD1 ,
The connection of connecting to a dataset is the live connection. You can only connect to one dataset in each report. In other words, a data source with live connection is not allowed to coexist with other data sources. This behavior is similar to the behavior when connected to SQL Server Analysis Services. However, the following article describes how a new feature in Power BI now makes this possible: see Using DirectQuery for Power BI datasets and Analysis Services (preview)
Best Regards,
ShundaSteph
Hi @LD1 ,
The connection of connecting to a dataset is the live connection. You can only connect to one dataset in each report. In other words, a data source with live connection is not allowed to coexist with other data sources. This behavior is similar to the behavior when connected to SQL Server Analysis Services. However, the following article describes how a new feature in Power BI now makes this possible: see Using DirectQuery for Power BI datasets and Analysis Services (preview)
Best Regards,
ShundaSteph