Forum Discussion
Issue with DAX function SummarizeColumns - Power BI Report Server September 2024
We have some report objects that use SummarizeColumns function that are not rendering when executed from the Report Server that we just upgraded to September 2024. The function works correctly when loading the same report, from the RS, using Power BI Desktop Report Server September 2024, as well as Power BI Desktop. Attached screenshot shows the error from the PBIRS, as well as a screenshot showing the graph loading properly in PBI Desktop RS. Is there something missing on our report server for this to render properly? Thanks
4 Replies
you would need to show more details about your measure. Does it involve CALCULATE ?
The measure is using AVERAGEX that calls SUMMARIZECOLUMNS.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
I posted to issues.
On a side note, I just noticed that the version of DAX libraries installed on my PBI Desktop RS (16.0.148.21) is different than what is installed on with Report Server (16.0.144.18). I am going to see if I can get a sys admin to replace the files on the report server as a test.
Microsoft.AnalysisServices.Dax.Extensions.dll
Microsoft.AnalysisServices.Dax.ExtensionInterfaces.dll
