Forum Discussion

Regular Visitor

9 years ago

Solved

See Records Option not available when using SSAS as connection

Hi Everyone, we are using SSAS as connection. Using this connection we have created a report and published a dashboard.

However, on the dashboard on right click 'See Records' option is not available.

Is this option not available for SSAS connection?

Thanks in advance !

parry2k
Super User
9 years ago
Yes this option is not available if you are using SSAS Live Connection. Thanks
Baskar
Resident Rockstar
9 years ago
If you using SSAS Live connection , u cannot able to see this options oops.
- Shishir
  Regular Visitor
  9 years ago
  Baskar parry2k thanks for the reply. In that case, do you know of any alternate solution to achieve same functionality.
  My requirement is , on clicking a visualization , a report should open with the details just like it open for 'See Records'
  
  Thanks!
  - parry2k
    Super User
    9 years ago
    Another option is to use "Import Data" but I know it is not practical specially when you have large dataset, so Live connection is the best option.
    
    or you can write a mdx query and use import data, that way you could have smaller data to import in powerbi (i dont prefer this thou) but throwing the option there.
    
    Also with live connection, you can drop a table on the report with required fields in it, once you click on the graph, it will cross filter, do you think that will not work?
    
    That is what I can think of, not sure if there is any other option.
    
    Thanks,
    Parv