calculation group
1 Topic
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