Forum Discussion
Help to build report by using 2 already published datasets using live connection
Hi, Kirana
You can connect to only one dataset in each report. The behavior is similar to a SQL Server Analysis Services (SSAS) connection.
In summary, Power BI datasets do not support composite models, and you cannot live connect 2 datasets at the same time.
Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Unfortunately, this is by design. Power BI is now unable to achieve what you need. You can submit an idea for it at https://ideas.powerbi.com/ideas/ and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, Kirana
You can connect to only one dataset in each report. The behavior is similar to a SQL Server Analysis Services (SSAS) connection.
In summary, Power BI datasets do not support composite models, and you cannot live connect 2 datasets at the same time.
Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Unfortunately, this is by design. Power BI is now unable to achieve what you need. You can submit an idea for it at https://ideas.powerbi.com/ideas/ and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.