Combining PBIX files

[BIMJ]

Hi,

I have taken offline copies of PBI datasets (pbix) monthly. They are published in the dedicated workspace to refer back in time.

We need to combine all these monthly pbix into a single file or dataflow. Anyways to do this? Each dataset holds a million records.

Thanks

[amitchandak]

@BIMJ , I think monthly pbix is not a good idea. You should put the datasource in the Database or folder and then load it power bi and merge data if needed.

if you want to merge meta then you can try the ALM toolkit

How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc