Power BI Desktop File for Different Datasets - Same Structure with Different Data

[atulkgoyl]

We have one PBIX file which has multiple pages/reports. We want to use it for different datasets (same structure and data is different).

Currently we create seperate PBIX file for each dataset. It becomes very challenging when we need to apply the same change to all the Power BI files.

What is the best way to manage it? Is there an option of doing some sort of DevOps or change management?  

[amitchandak]

@atulkgoyl , if data is together you can try for RLS 

or You use ALM tool kit to merge new changes in the files

[atulkgoyl]

Thank you @amitchandak . What is the best way to learn about ALM tool kit? That might work.

We considered RLS but the data is huge for each client. Using one dataset will slowdown the performance.

[amitchandak · Accepted solution]

@atulkgoyl , ALM toolkit is for merging the code between various power bi files or file or service so that you can change code at a different places.

refer my video

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

refer: https://www.sqlbi.com/tools/alm-toolkit/