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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!