Export data from visual to excel not working right

[clayduvall]

I'm having an issue in the power BI service.   When I choose the export data option from a visual and choose excel, the data doesn't match th visual.  There are many more records in the results.  When I choose csv it works.  Is anyone aware of a bug in the export data to xlsx feature?

[Anonymous]

Hi @clayduvall 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?

Thank you very much for your kind cooperation.

Best Regards

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

[Anonymous]

Hi @clayduvall 

Make sure the option is enabled in the desktop:

Select the option for Summarized data if you want to export data for what you see in that visual. This type of export shows you only the data (columns and measures) that are being used to create the visual. 

Best Regards

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

[clayduvall]

Thank you for your response.  This option is enabled.  I can export summarized data.  The problem is that the csv export works correctly, exporting exactly what is on the visual.  But the xlsx export export many more records as if the visual filters are not applied.  I believe it has to be some bug with the xlsx export.

[Anonymous]

Hi @clayduvall 

In my test, this feature works fine, it might be a transient problems.

Maybe you can try to republish the report to another workspace and check if it could be solved.

Given I have so little information at this time, I can't tell what's causing your problem.You can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Fabric Community

Thank you for your understanding.

Best Regards

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

[SaiTejaTalasila]

Hi @clayduvall ,

Please check this -

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

Thanks,

Sai Teja 

[rubayatyasmin]

Hi, @clayduvall 

see: https://community.fabric.microsoft.com/t5/Desktop/EXPORTED-DATA-NOT-MATCHING-VISUAL/td-p/2769705

this might help: https://community.fabric.microsoft.com/t5/Service/Export-to-excel-not-working-as-expected/m-p/347852...

see if you are facing any limitations: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

https://community.fabric.microsoft.com/t5/Issues/Power-BI-not-exporting-all-rows-from-a-table/idi-p/...