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

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
Moderator v-sihou-msft
Moderator

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

@Sisyphus

 

 "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, 

3 REPLIES 3
Moderator v-sihou-msft
Moderator

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

@Sisyphus

 

 "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, 

Sisyphus Frequent Visitor
Frequent Visitor

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.

em172967 Frequent Visitor
Frequent Visitor

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

What did you do?