Forum Discussion

BIMJ's avatar
BIMJ
Frequent Visitor
3 years ago

Combining PBIX files

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

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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