Below is my observation -
Currently, 'See Records' option is enabled only when the measures and dimensions that are actaully present in database/source are used (Import data > drag measures & Dimensions to visualisation > Click on the visualisation and then you have ' See Records' Option active.
If you are trying to import the data > create new measure in pbi desktop > Drag the new measure in the visualisation then the 'see records' option is not enabled.
I hope the next release will fix the above issue and enable the 'see records' option even if the calculated measures are included in the visualisation.
Please correct me if the solution is already available.
I guess it didn't make it. It is enabled only if a measure is not used.
Is the "See Records" option available for measures the May update? It seems it is still disabled for calculated measures for the May version.
Thanks so much.
Im using Jun month release version , but still "See Records" optoin disabled for Calcualted measures ,Tolltips and Color Satuaration option . Please let me know if you have any idea .
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!
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.
Just retested this with the Feb 2017 release of Power BI Desktop - it still shows the original, so-called functionality, which is practically useless.
@pbix - 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.
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?
Getting to be a year later and we still can't drill down when measures are included in a visualization. Has this been forgotten? Users are getting pretty frustrated that they can't drill down in visuals. I shouldn't have to manipulate things to not use measures so they can drill down.