Forum Discussion
Export Data from Power BI Service does not export all the underlying data
Hi jeaninnes
From my understanding when you export the data from a visual it simply exports the data that makes up the visual.
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/
Hi @guavaq,
thanks for the reply. 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. I'm not sure if this then makes it more difficult to view the dataset underneath.
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.
It appears to me that it's not recognising the whole data relationship or something like that.
best regards,
Jean
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,
AngeliaHi 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.
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.
