cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

Hey all,

 

I'm currently doing a live connection from Azure Analysis Services to Power BI Desktop. The connection is successful and I see my dimensions and fact table showing up in the report.

 

The issue is that whenever I try to create some visuals, I cannot make a column aggregate (i.e. sum, count). This has happened with my current model where I'm not able to aggregate data in the reporting layer. Screenshot below of the options I should be normally seeing vs. what I currently see with my current model connection:

 

Typical Aggregation Option View - Using Data Source from a DirectQuery (non-Analysis Services)

 

PBI_Aggregation_Normal_5.27.2020.PNG

 

Current Option View with no Aggregation Options shown (Using Azure Analysis Services)

 

PBI_Aggregation_Issue_5.27.2020.PNG

 

Any feedback or suggestions are appreciated, especially if there is something that has to be done at the Analysis Services layer. Thank you!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

Hi @cafe_cortado ,

 

Do you connect to Tabular or Multidimensional? 

 

I tested with SSAS(on-prem).

For Tabular, columns could be aggregated.

 

tabular.jpg

But for Multidimensional, columns couldn't be aggregated. I'm not sure if it was possible before. 

Multidimensional.jpg

 

In your scenario, if last week, (1) it was connected to Multidimensional and (2) columns could be aggregated. But it doesn't work currently and you are a pro user, it is suggested to create a support ticket to get further help.

 

Support Ticket.gif

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Super User IX
Super User IX

Re: Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

@cafe_cortado , what is the data type of Name. Is it a Measure?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

Hey @amitchandak ,

 

Thanks for replying. The Name column currently shows a data type of "Text" and is a table column, not a measure. The aggregates showed up last week, but now they do not appear at the moment.

This issue also applies to other fields with a data type of "Decimal Number".

 

PBI_Aggregation_Name_5.27.2020.PNG

Highlighted
Super User IX
Super User IX

Re: Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

@cafe_cortado , Check if you are facing after May 2020 release upgrade. If so check and log ticket at : https://community.powerbi.com/t5/Issues/idb-p/Issues



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

Hi @cafe_cortado ,

 

Do you connect to Tabular or Multidimensional? 

 

I tested with SSAS(on-prem).

For Tabular, columns could be aggregated.

 

tabular.jpg

But for Multidimensional, columns couldn't be aggregated. I'm not sure if it was possible before. 

Multidimensional.jpg

 

In your scenario, if last week, (1) it was connected to Multidimensional and (2) columns could be aggregated. But it doesn't work currently and you are a pro user, it is suggested to create a support ticket to get further help.

 

Support Ticket.gif

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

Hey all,

 

Thanks for providing insights on how to best approach this topic. It seems like it's an issue that warrants a support ticket. The server is run on Azure Analysis Services, so it's set by default to be in tabular view. Screenshot below with sensitive information redacted.

 

AAS_properties.png

 

I will work on using the Support Ticket system to get this resolved. Thank you everyone!

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors