See Records Option not available when using SSAS as connection

[Shishir]

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 !

[Baskar]

If you using SSAS Live connection , u cannot able to see this options oops.

[Shishir]

@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 · Accepted solution]

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

[parry2k]

Yes this option is not available if you are using SSAS Live Connection. Thanks