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.