Forum Discussion
Merge two BPIX files
I have two PBIX files which are based on two different Folder CSV imports. There are quite a lot of transformations in the basic import including custom functions and based on each import in each PBIX file there are about a dozen filtered tables.
Now, after working with both files, I recognized that it would be smarter to have them both in one file so I can work on both data sets.
Is there an easy way to copy all tables and the dependend imports from one file into another?
Cheers, Zap.
5 Replies
Hi Anonymous
Please go to Tranform Data i.e Power Query andin th eHome tab of the tools header in the top right corner you will find Merge and Append queries. With those you can combine both the files.Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Anonymous , no way to merge the pbix. You can merge or append data
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Later once you same model at both place you can copy paste visuals from one pbix to other
Hi Anonymous ,
Check the following setps.
1# Open pbix file A and open Query Editor. In Query Editor, select table and open Advanced Editor then copy the query.
2# Open pbix file B and open Query Editor. Copy a table and open Advanced Editor then paste and replace the query.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you still couldn't solve this problem maybe I can help you the way I did.
go to Power Bi desktop, index data and select the following:
You can select your dataset from a PB that you have already made and published, in this way you will obtain within the same PB the queries, measures the only thing you should copy is the visual aspect.
