Forum Discussion
simultaneous work on Power BI dataset problem
After checking both links I chose this workaround. Maybe someone is interested.
It needs a little bit of manual work but for us it seems ok for now.
1. After you have done your work on the pbix file, you open the tabular editor and save the .bim file.
2. then track the .bim file with git so you have always the newest version. and it should also be merged by git if multiple persons made different changes. (if you have conflicts you have to merge this manually)
3. when you start to work again, pull the newest version of the .bim file and open your pbix in desktop (which hasn't the newest model information inside yet).
4. open the ALM Toolkit and select the .bim file as source and your opened pbix as your target. then update everything possible by ALM toolkit and refresh the comparison. after that, everything except queries should be updated (which is better then nothing i think 🙂 ).
5. then open the tabular editor and load the .bim file too. figure out wich differences still exists by using ALM toolkit. and copy paste the query code manually in your queries in your opened pbix. (why tabular editor? and not copy paste it out of the alm toolkit? yea unfortuantely the format inside alm toolkit is in the .bim format and not in power query m format.. in tabular editor you have the format you need)
i think this is just a few minutes of work when you begin your session and its worth it (for us).
hope that helpes. (sorry for my rudimentary english)best regards
elaj
elaj check this link Migrate Analysis Services models to Power BI using Tabular Editor – Data – Marc (data-marc.com)
and also check ALM Toolkit Home Page - ALM Toolkit (alm-toolkit.com)
After checking both links I chose this workaround. Maybe someone is interested.
It needs a little bit of manual work but for us it seems ok for now.
1. After you have done your work on the pbix file, you open the tabular editor and save the .bim file.
2. then track the .bim file with git so you have always the newest version. and it should also be merged by git if multiple persons made different changes. (if you have conflicts you have to merge this manually)
3. when you start to work again, pull the newest version of the .bim file and open your pbix in desktop (which hasn't the newest model information inside yet).
4. open the ALM Toolkit and select the .bim file as source and your opened pbix as your target. then update everything possible by ALM toolkit and refresh the comparison. after that, everything except queries should be updated (which is better then nothing i think 🙂 ).
5. then open the tabular editor and load the .bim file too. figure out wich differences still exists by using ALM toolkit. and copy paste the query code manually in your queries in your opened pbix. (why tabular editor? and not copy paste it out of the alm toolkit? yea unfortuantely the format inside alm toolkit is in the .bim format and not in power query m format.. in tabular editor you have the format you need)
i think this is just a few minutes of work when you begin your session and its worth it (for us).
hope that helpes. (sorry for my rudimentary english)
best regards
elaj