Forum Discussion

jeaninnes's avatar
jeaninnes
Frequent Visitor
8 years ago

Export Data from Power BI Service does not export all the underlying data

Hi there,  I have a report that shows 4 columns. Actuals (table1) Forecast (table1) Opportunity Forecast (table2) Budget (table3)   The relationships are set between the tables - basically bot...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi jeaninnes,

When you click the elliplses on the right top of visual->show data, the 4th column has no data? And what's meaning of "export the summary data"? Could you please share more details?

Best Regards,
Angelia

jeaninnes's avatar
jeaninnes
Frequent Visitor
8 years ago

Hi Angelia, 

Steps to reproduce:

1. Chart published to power BI service.

2. Chart contains 4 columns of data.  These come from 3 tables that are joined via relationships.

3. Elipses: Show Data works fine.  I can see my 4 columns & their amounts.

4. Elipses: Export Data : Summarised Data also works correctly.  I get an excel spreadsheet with the column amounts as I would expect.

5. Elipses: Export Data : Underlying Data does not give me all the underlying data.  I will post screen shots.  It appears to give me data from two of the tables, but not the third.  My users want to be able to have a table with all the underlying data that totals to give the summary information that I'm displaying - but it looks like it will only do this IF your underlying data is all in the one table OR in a maximum of two tables with a re;ationship join.  

  • jeaninnes's avatar
    jeaninnes
    Frequent Visitor
    8 years ago

    these are the headers for my summary data - which is working as I would expect.  

     

    When I export the underlying data, I don't see any OppyForecastRevenue columns at all.  So there's no way to see what is contributing to these summary totals.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi jeaninnes,

      Got it. After research, there are some limitations and considerations for Export Date, please review the part in this article. Please check your report or dataset has items considered in the limitations.

      • When using DirectQuery, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.

      • Power BI only supports export in visuals that use basic aggregates. Export is not available for visuals using model or report measures.

      • Custom visuals, and R visuals, are not currently supported.

      • Export data is not available for users outside of your organization who are using a dashboard that has been shared with them.

      • If there is unicode character in the .csv file, the text in Excel may not display properly. Although, opening it in Notepad will work fine. Examples of unicode characters are currency symbols and foreign words. The workaround for this is to import the csv into Excel, instead of opening the csv directly.

       
      Best Regards,
      Angelia

      • franck_axires's avatar
        franck_axires
        Frequent Visitor
        7 years ago

        Hi jeaninnes 

        Check if you have measures stored in a dedicated table and not in the table where the data they use resides.

        For some reason, trying to export data from a visual that uses measures will only export the aggregate data if the measures' home table is not where their data resides.

        If this is the case, just move them back to their data table and the underlying data export will work just fine.

        Hope the PBI Team finds a way soon to let us visually group measures as this is much more convenient than have them spread around the fact & dimension tables alphabetically...