Forum Discussion
Unable to save datamart - DmsPbiServiceUserException
Correct--I did verify that I still have access to the source databases, and nothing has changed there. The error message does suggest redeploying, but I don't know what that means in the context of a datamart. In the end, I copied all of the queries (actually quite fast, since you can ctrl-c/ctrl-v 40 queries together) into a new datamart, and I have not had issues since.
I have to blame the issue on trying to change the owner of the datamart--trying to take it over as I would a dataflow. I will not try that again for the forseable future 🙂
I raised this particular bug with Microsoft Support on the 2nd Nov 2023 via the Support Portal, I was told it was officially recognised as an issue with the Power BI Service yesterday and the ETA for a fix is the second week of December (I'm hoping 2023!) so until that point I would suggest backing up any Measures and Advanced Queries you create directly in the PBI Service in a separate text file if you use PBI Data Marts just in case as the only current solution (if you'd call it that) may be to recreate the Data Mart from scratch!
If you opt for recreating the data mart, a big problem we had was how to connect the current PBI Reports to the new Data Mart created; this was done by downloading the PBI Reports with online connection, unzipping the PBIX file, changing the Connections file to point to the new Data Mart name and link (which can be taken from a different PBIX file connected to the new Data Mart at a push) and then rezipping them to follow the same structure and renaming them back to a PBIX - not ideal but could save hours of report rework. I'll update this comment if I find out more or a better way to do this and please keep a backup before trying this.
Thank you for sharing this, I have been having issues related to this bug. Messages like: "Unable to sync the datamart with the automatically generated dataset", or simply just missing tables/sources from the Explorer>Tables. Hopefully, this will be fixed by mid-December. Datamarts are an awesome feature, however, this particular issue might delay the adoption in our company.