Forum Discussion
Kudo CollectorMerge datasets into single report or use dataset as source
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.
Kudo CollectorHi 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.
This is a big issue for us. We need to combine different datasets. Each dataset has been created with specific credentials that should be given to other developers. For example, our HR group has created datasets with lists of employees. We need to use these datasets for other purposes. But the HR will NEVER give access to the HR data source so we can create our own reports. It would violate so many privacy issues. We need a way to connect one Power BI dataset with another. I find this a very limiting feature in Power BI.
