Forum Discussion

SHHargrove's avatar
SHHargrove
Icon for Advocate II rankAdvocate II
10 years ago

April Update -- Not able to enable See Records or synonyms

Hi All, Really enjoying the grid formatting options with the April Update.  However,some of th other new features don't seem to be working for me: Enable See Records:  I see the option in the Dril...
Shishir's avatar
Shishir
Regular Visitor
9 years ago

Hi Lydia,

We have a similar challenge. We are using SSAS as connection. Using this connection we have created a report and published in Power BI . However, in this report on right click 'See Records' option is not available.

 

Is this option not available for SSAS connection? 

 

Thanks for your help in advance!

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Just wanted to confirm the above post:

 

Are we still not able to view record data when connecting live to SSAS as a data source? For both Tabular and Multi-dimensional?

 

We have to much data in our SSAS cubes to re-create our cubes in the Power BI environment to 'see records' by importing data into desktop files.

 

Thanks!

  • mike_honey's avatar
    mike_honey
    Icon for Memorable Member rankMemorable Member
    9 years ago

    Just retested this with the Feb 2017 release of Power BI Desktop - it still shows the original, so-called functionality, which is practically useless.

  • sdjensen's avatar
    sdjensen
    Icon for Solution Sage rankSolution Sage
    9 years ago

    Anonymous - To my knowledge it will not help if you recreate your Tabular model in a .pbix file. The "See Records" function only works if you add a column directly from a table as a measure and not for a calculated measure/column.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi sdjensen, mike_honey

       

      Thanks SD, Mike - v much agree - it looks like you cant drill through where you use a calculated measure in SSAS - but we can drill through on a calculated measure when browsing the cube in Excel.

       

      Is there any feeling for when this functionality will come to Power BI - i.e. drill through to data behind a calculated measure in SSAS?

       

      Thanks!

       

      Pbix