Forum Discussion
Kudo CollectorMerge datasets into single report or use dataset as source
Kudo Collectordo you mean paste as in a static one time copy paste, or are you saying that excel can query the individual pbix files as data sources.
a one time export isnt going to help unfortunately as this a comstanty updating report.
if you mean the latter i must confess i am unfamiliar with excels ability to query powerbi
Kudo Collectorok lydia scrub that last comment. ive just read up on excel querying powerbi. completely missed that release. i will try that out and report back.
- warrencowan
Hi Lydia, I dont think this can work as when you change the sign in settings for salesforce in the pbix file, all the other pbix files inherit it. am I missing something
- warrencowan
Hi Lydia, I dont think this can work as when you change the sign in settings for salesforce in the pbix file, all the other pbix files inherit it. am I missing something.
Hi warrencowan,
I mean that you copy entire table of each PBIX file, then press Ctrl+V to paste these data in Excel. After you merge data of these tables in a single table in Excel, then connect to the Excel file in Power BI Desktop.
Thanks,
Lydia ZhangI have the same issue. Is there a simple way to merge two or more datasets, without having to copy and paste queries for each table separately?
I am creating a core data model and the different domains are created in separate files (PBIX). There are 7 domains, each having anywhere from 13 to 22 tables. Copy and pasting each is a lot of extra work and not to mention the refresh that happens on each commit. This is why they were kept separate to minimize the load from other domains in the modeling phase.
