Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Dynamic Top N Dashboard with Analysis Services Connection

Hello,

 

I am looking to do something like what is shown in the below video (creating a toggle to select which Top N to show), but my data set is a Live Connection to Analysis Services. As such, I don't have the ability to add tables (and my IT team owns the underlying data and is reluctant to add things on the backend). Is there another way to do this / a workaround for when you are linked up to Analysis Services?

 

https://www.youtube.com/watch?v=JUgROZURmrs

 

Thank you!

Hannah

1 ACCEPTED SOLUTION

 

Hi @Anonymous ,

 

Yes, if you use connect live mode ,there is no way to dynamically change the top N currently.

 

While you may post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

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

3 REPLIES 3
v-xicai
Community Support
Community Support

Hi @Anonymous ,

 

When you connect to SSAS using connect live mode, it is not supported to create new table and calculated column, while you can only create report level measures for SSAS Tabular Model in Power BI Desktop . However it still can't achieve your demand of dynamic top N selection filter.

 

So recommend you using Import mode instead of connect live mode when connect to SSAS in your scenario.

 

Best Regards,

Amy

 

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

Anonymous
Not applicable

Thank you, Amy! That's helpful. My organization requires live connection because they don't want people manipulating the underlying data in any reports (so there is one source of truth) and so that data updates are pushed in automatically. If this is the case, then there is no way to dynamically change the N seen, correct?

 

Thanks for your help!

 

Hi @Anonymous ,

 

Yes, if you use connect live mode ,there is no way to dynamically change the top N currently.

 

While you may post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.