cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

See Records Option not available when using SSAS as connection

Is there a way to activate "See Records" when using a cube connection? The community dialog suggests this option is not available. 

 

My problem is I need to be able to prove to my user-base the elements that are included in a sub-total to properly assess the level of trust a user can apply to the sub total.  For example

- When viewing staffing levels data, my graph says I have 10 employees in my team when I "know" I have 12.

- My 1st question will be "who is in and who is out"

- If not quickly and easily answered the system is thrown out with the trash irrespective of accuracy 

 

The answer to be proved is almost always the temporality of the data (month old) vs my users' understanding (now). But this has to be proved concretely & quickly.

 

How is the proof to be made available to the end user.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: See Records Option not available when using SSAS as connection

@Anonymous

 

 "See Records" is not avaialbe when you open a live connection to SSAS. 

 

 

In Power BI Desktop, for connecting SSAS, either Tabular or Multidimensional, it's not possible to see the detail limited rows or sets defined in Role setting.

 

Regards, 

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: See Records Option not available when using SSAS as connection

@Anonymous

 

 "See Records" is not avaialbe when you open a live connection to SSAS. 

 

 

In Power BI Desktop, for connecting SSAS, either Tabular or Multidimensional, it's not possible to see the detail limited rows or sets defined in Role setting.

 

Regards, 

View solution in original post

Highlighted
Anonymous
Not applicable

Re: See Records Option not available when using SSAS as connection

I have created another way to see sub total breakdown information so the "See Records" option is now a nice to have.

Highlighted
Frequent Visitor

Re: See Records Option not available when using SSAS as connection

What did you do?
Highlighted
Frequent Visitor

Re: See Records Option not available when using SSAS as connection

Since this is a standard feature when browsing a cube in Excel, I'm wondering whether this is planned for Power BI or not? It seems like an odd choice to leave this out.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors