Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Export excel under power bi report

Hi All!   I've created some reports on power bi. I used excel file on sharepoint as source. Then I published the reports online to share them with my colleagues. Do you know if it possible to set a...
  • MAwwad's avatar
    3 years ago

    Yes, it is possible to allow your colleagues to download the underlying data in Excel or CSV format from your Power BI report. You can do this by enabling the "Export Data" option in your Power BI report.

    Here's how you can enable the "Export Data" option:

    1. Open your Power BI report in the Power BI service.
    2. Click on the "File" menu in the top-left corner of the screen.
    3. Select "Report settings" from the dropdown menu.
    4. In the "Export data" section, toggle the switch to the "On" position.
    5. Choose the data export format that you want to allow your colleagues to download (Excel or CSV).
    6. Click on the "Apply" button to save your changes.

    Once you've enabled the "Export Data" option, your colleagues will be able to download the underlying data in Excel or CSV format by clicking on the "..." icon in the top-right corner of the visual and selecting "Export data" from the dropdown menu.

    Note that the "Export Data" option will only be available for visuals that have underlying data, such as tables or charts. Also, depending on the data source, there may be limitations on the amount of data that can be exported.