Forum Discussion

poojithas's avatar
poojithas
Icon for Helper III rankHelper III
3 years ago
Solved

Export all tabs to Excel

Hi All,

I have a Power BI report with 4 tabs. This report is embeded in external portal. We now have a requirement to export all the 4 tabs to excel in one go rather than doing it 4 times individually.

Could someone let me know if this is possible.

Thank you.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi poojithas ,

    So far, to my knowledge, there is no way to export report to excel file.

    Could you please try Analyze in Excel, With Analyze in Excel, you can create an Excel workbook containing the entire dataset for a specific Power BI report and analyze that dataset in Excel using PivotTables, Pivot Charts, and other Excel features.

    For more details, you can read related document: Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi poojithas ,

    So far, to my knowledge, there is no way to export report to excel file.

    Could you please try Analyze in Excel, With Analyze in Excel, you can create an Excel workbook containing the entire dataset for a specific Power BI report and analyze that dataset in Excel using PivotTables, Pivot Charts, and other Excel features.

    For more details, you can read related document: Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.