Forum Discussion

Shishir's avatar
Shishir
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...
Need Help
  • parry2k's avatar
    parry2k
    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

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

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

 

Shishir's avatar
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's avatar
    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