jan2025
2 Topics
Calculation group issue PBIRS
So we recently updated our report server and desktop setup to January 2025 version and with it came a great bunch of new functionalities! As I was trying out the calculation groups functionally, I learned the hard way that it is not quite ready yet. If you have a model which is using direct query, then add a calculation group. The group automatically has storage mode "import", which makes the model a composite model. Which as far as I have understood is not supported for pbi report server(yet). So when I saved my report to the server, closed desktop and the next day tried to reopen my report I got the error message that my file is using a composite model and it's not supported in pbi report server. So I couldn't open it anymore, meaning I couldn't remove the calculation group. Meaning I had to grab an older version of my report and copy that data model into my new one and redo all of my work. I also tried opening it locally but it's the desktop version that doesn't support the model so that didn't help either. I don't have the option to open the report in a "regular" pbi desktop to fix it either. I think maybe the calculation groups option shouldn't be accessible if it basically breaks your dataset(with import data) if you are using direct query. I am not sure if this is a "bug" or if I as a user/developer should know about this but it seems to me like maybe the calculation groups setting should either be turned off or at least warn if you have a model using direct query storage mode. Petebro Let me know if there are any more specifications you need from me, but I assume this is a general thing. TLDR: PBI Report server + Direct query storage mode + adding calculation group = BadSolved1.7KViews2likes3Comments
Power BI Report Server January 2025 has been Released!
We are pleased to announce the January 2025 update for Power BI Report Server. The release can be found on the Microsoft Download Center. All updates can be found on the change log page. As always if you encounter an issue please contact support and/or create a new thread with as much detail as possible and tag Petebro and I will try to reply as quickly as possible.Solved6.2KViews5likes1Comment