Export underlying Data

[wildturkey]

Morning

Is there a function in Power BI similar to that of double clicking a cell on a pivot and getting the underlying data out please? I've tried the 'allow end users to export both summarised and underlying data' but think I may be down the wrong path to start?

Thanks

 

[Matt Allington]

Nope, that’s the setting. you Can also use Analyze in Excel and do it the same way as you describe

 

[wildturkey]

Maybe a little more playing, but finding that I have Power BI open and if I identify any strange data values I open Excel and pivot to explore.. Export data only gives me the level I'm looking at and nothing further - probably user error