Forum Discussion
Exporting to Excel PBI report published in Service - Behaviour between list/matrix vs Other Visuals
Hello
I would like to export underlying data existing in a visual (like a chart) to an Excel file. I did activate the "export underlying data" in the PBIX file before publishing it to the service, but i don't know the setup on PBI Service.
From what i've read and seen on the export menu that appears, it seems that you can export underlying data, with filters, to an Excel file, without issues, as long as you start from a table or a matrix.
I was assuming that from other visuals it would always fail, but i got to the conclusion that of you're using a something like a chart it might or it might not work, i've had a test with success, and others failing, either PBI service saying it can't export, or Excel online opening and saying "you might have corrupted or missing data if you try to recover".
Can you please confirm this behaviour? Could it be some set placed by PBI Admin that is stopping me from having good export from visuals, or is it a limitation from PBI Service?
Regards
Hello Ricardo,
1st, check the Report Export settings
2nd, check the Admin Export settings:
3rd, check the individual visual header properties:
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedIn
3 Replies
- GilbertQ
Super User
- RicardoV2Frequent Visitor
Hello, it's using both.
- pmreis
Most Valuable Professional
Hello Ricardo,
1st, check the Report Export settings
2nd, check the Admin Export settings:
3rd, check the individual visual header properties:
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedIn