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

Question

Hi there,&nbsp;I have a report that shows 4 columns.Actuals (table1)Forecast (table1)Opportunity Forecast (table2)Budget (table3)&nbsp;The relationships are set between the tables - basically both table1 &amp; table2 join to table3 to compare to the budget.&nbsp; The chart works well &amp; I can see the underlying data records when I interact with the report.&nbsp;&nbsp;My users would like to be able to export the entire data list behind the report so that they can build other reports.&nbsp; &nbsp;The report has been published to the power BI service.However when the users do this, it appears to only extract data from table1 and table3 - &gt; so I can't see the opportunity forecast values.How can I correct this?&nbsp; I just want to show all the data that makes up the report and it appears I can't do this.

gilbertq · Answer

Hi&nbsp;jeaninnes&nbsp;From my understanding when you export the data from a visual it simply exports the data that makes up the visual.&nbsp;If you users want access to the dataset I would suggest using the Power BI Publisher for Excel. This will enable them to connect to the dataset, and they can then leverage this to get the data that they require.https://powerbi.microsoft.com/en-us/excel-dashboard-publisher/

jeaninnes · Answer

Hi&nbsp;@guavaq,&nbsp;thanks for the reply.&nbsp; I've attempted to use this - but it's not working for me.To provide a little more context, my powerBI report is connecting to a Dynamics365 datasource.&nbsp; I'm not sure if this then makes it more difficult to view the dataset underneath.&nbsp;&nbsp;When I export the summary data, I get the 4 data columns I'm after, but when I export the underlying results, I don't get that 4th column.&nbsp;It appears to me that it's not recognising the whole data relationship or something like that.best regards,&nbsp;Jean&nbsp;

v-huizhn-msft · Answer

Hi&nbsp;jeaninnes,When you click the elliplses on the right top of visual-&gt;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 · Answer

Hi Angelia,&nbsp;Steps to reproduce:1. Chart published to power BI service.2. Chart contains 4 columns of data.&nbsp; These come from 3 tables that are joined via relationships.3. Elipses: Show Data works fine.&nbsp; I can see my 4 columns &amp; their amounts.4. Elipses: Export Data : Summarised Data also works correctly.&nbsp; 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.&nbsp; I will post screen shots.&nbsp; It appears to give me data from two of the tables, but not the third.&nbsp; 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. &nbsp;

jeaninnes · Answer

these are the headers for my summary data - which is working as I would expect. &nbsp;&nbsp;When I export the underlying data, I don't see any OppyForecastRevenue columns at all.&nbsp; So there's no way to see what is contributing to these summary totals.

Forum Discussion

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

7 Replies

Related content

Underlying Error: OnPremiseServiceException

Export underlying data

Export Underlying Data is not exporting all columns

Underlying ErrorOnPremiseServiceException

Export Underlying data option disabled