Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

brandonmcg

Power BI Report Server September 2024 - Issue with DAX function SummarizeColumns

Submitted by on ‎11-05-2024 04:49 AM

We have report objects that call the SummarizeColumns function, inside an AVERAGEX 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. I posted this to the Report Server forum but it was suggested that I post here under issues. Thankssummarizecolumns.png

Status: Investigating
See more ideas labeled with:
4 Comments (4 New)
Comments
brandonmcg
Regular Visitor
‎11-05-2024 05:47 AM

NOTE: I have noticed that the DAX extension libs included with Power BI Desktop Report Server September 2024 are a newer version than what is included with Power BI Report Server September 2024.

Sep 2024 Desktop

Microsoft.AnalysisServices.Dax.Extensions.dll 16.0.148.21
Microsoft.AnalysisServices.Dax.ExtensionInterfaces.dll 16.0.148.21

Sep 2024 Server

Microsoft.AnalysisServices.Dax.Extensions.dll 16.0.144.18
Microsoft.AnalysisServices.Dax.ExtensionInterfaces.dll 16.0.144.18

Anonymous
Not applicable
‎11-05-2024 05:50 PM

Hi  @brandonmcg ,

 

In order to better reproduce your problem, we need more detailed information. What data source and connection model are you currently using? Can this issue be reproduced in any data source or connection mode?

 

Best regards.
Community Support Team_Caitlyn

brandonmcg
Regular Visitor
‎11-06-2024 12:52 PM

Hi @Anonymous 

Thank you for responding. We are importing the data from a MSSQL data source. We have not tried to reproduce the error using another data source type as the MSSQL data import is the only method we need for our reports.

Anonymous
Not applicable
‎11-07-2024 07:04 PM

Hi @brandonmcg ,

 

I see the version information you provided and it appears that you are not using Power BI Report server but SSRS.This feature works fine in Power BI Report Server.
The latest version of Power BI Report server is as follows：

vxiaoyanmsft_0-1731034969470.png

Download Microsoft Power BI Report Server- September 2024 from Official Microsoft Download Center

 

 

Can you reconfirm if this issue is happening in PBI RS, if it is SSRS you need to go to its dedicated forum for support.

 

Best regards.
Community Support Team_Caitlyn

Idea Statuses