Forum Discussion

RicardoV2's avatar
RicardoV2
Frequent Visitor
2 years ago
Solved

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

  • pmreis's avatar
    pmreis
    Icon for Most Valuable Professional rankMost 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