Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issue with "Underlying Data Export ".

Hello,   We have a table visual with few measures represented as columns.   While exporting the data from a table visual using "Underlying Data" feature, Power bI was not flatenning the exporte...
Need Help
collinq's avatar
collinq
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

I am not quite sure what you are striving for - when you export the data, you are exporting the data that is behind the visual.  So, the underlying data will provide the data that creates the visual and not necessarily every single data source in the dataset.  Also, if you have RLS applied this will affect the outcome.  And, if you have filters applied then that will affect the output as well.  Aggregrations are flattened and removed as well.  There is also a limit to the number of rows being exported and that might be a limit for you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi collinq ,

    I am trying to extract data from a table. The table contains Customer name, Year Month, and some measures (below screenshot). When I try to export “Underlying data ” from the table visual, it only exports the overall measure value and not the underlying data which are connected to it.

    EXPORTED FROM :

     

     

     

    EXPORTED RESULT 

     

     

    DATA MODEL

    • collinq's avatar
      collinq
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous ,

       

      Thanks for the diagram.  I can't recreate the problem.  In my tests, it is working fine and as expected.  Would you be willing to put the file in a file share somewhere and let me access it and see what I can do?  I test with and without filters, with and without the sum field (fyi - without the summation field [the 5469] being in the aggregration, you can't do underlying data).