Showing results for 
Search instead for 
Did you mean: 
New Member

Data integration



I have enquiries regarding data integration. Basically, the objective of the project I'm assigned to is to merge multiple pbi dashboards into one pbi file given that we're able to manipulate the data. 


The different dashboards can be merged into one pbi file by "pinning" them live in the dashboard. However, the disadvantage is that we can't manipulate the data in the pbi file.


Looking forward for an open discussion regarding this matter. Thanks!


Great day 😁




Community Support
Community Support

Hi @tasnimpahlavi 


Not sure if I understand your requirement correctly. If you want to get data from multiple published power bi reports and create a new report based on these data, you could explore the Using DirectQuery for datasets and Azure Analysis Services (preview) feature. With this preview feature, you can connect to several Power BI datasets in DirectQuery mode and use them in a PBIX file. There are also some limitations and considerations to consider if you want to use it. Find the considerations in above link. 


Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!