cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BW938337
Frequent Visitor

Summarized data export to Excel in Embedded tier produces columns with no data

Hello, in our app (using Embedded service), exporting to Excel only works from a matrix and using the first export option (Data with layout). Exporting summarized data only produces a sheet with columns, but no data. CSV works fine. The service principal has admin permissions and the report allows users to export summarized data. I can export to Excel from the report directly from the PowerBI.com site, but this does not work in Embedded. Does anyone know why this is occurring? 

2 REPLIES 2
BW938337
Frequent Visitor

I did some additional testing. When I upload a new dataset (which only had three rows directly entered via PowerBI desktop vs a database source), and create a new report, then the report exports summary data successfully to Excel in Embedded. However, it is not doing it with my data model. I verified that my relationships are correct. I don't understand why .csv summary export works while Excel does not. Again, all the summary exporting works directly from the PowerBI site, just not in Embedded.

v-yangliu-msft
Community Support
Community Support

Hi  @BW938337 ,

You should export underlying data in power bi when you want to see the relevant data and additional data from the data model you have created in Power BI. However, if your visual contains an aggregation, it will not be exporting the aggregated data.

Summarized data will  show the columns and measures that you created for the visualizations. If the visual contains aggregation, the export will contain aggregated data.

 

Refer to:

Export data from a visual in Power BI embedded analytics | Microsoft Docs

This is the related document, you can view this content:

Solved: Export data in power BI embedded - Microsoft Power BI Community

How To Export Underlying Data in Power BI (designmind.com)

Issue with "Underlying Data Export ". - Microsoft Power BI Community

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.