title: how to export underlying data in Power BI report for live connection
body: <p>I am encountering a problem with all visuals on all Power BI (PBI) reports.  I use a &quot;shared dataset&quot; architecture.  That is, several reports will source from a single dataset.  This is achieved by a Live connection (with a dataset in the PBI Service as the source, as opposed to Azure Tabular as the source).  If it matters, for this particular situation, the PBI Service puts the dataset into Analysis Services.</p>
  <p>My users need to export the underlying data from all visuals.  I have enabled this option on all &quot;model&quot; and &quot;report&quot; pbix files.  Also, I have enabled the Build permission on all reports (at the app level).  However, when a user selects Export data \ Underlying data, it returns just 1 row of the measures / aggregates.  It's not even slicing it by the dimensions as with Export data \ Summarized data (i.e., &quot;Underlying data&quot; is less granular than &quot;Summarized data&quot;, which is backwards).  How do I resolve this?</p>