Forum Discussion
Power BI Desktop File for Different Datasets - Same Structure with Different Data
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?
Anonymous , 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
3 Replies
Anonymous , if data is together you can try for RLS
or You use ALM tool kit to merge new changes in the files
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.
Anonymous , 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