Forum Discussion

EZimmet's avatar
EZimmet
Icon for Resolver I rankResolver I
4 years ago
Solved

Power BI Export - Scheduling and Send Export to Excel by Email

I have a Power BI Premium User Licenses, created a Premium workspace it shows the diamond    I have a dashboard with a fully filtered Excel Report that I need to use the subscribe feature to...
Need Help
  • nitishsh91's avatar
    nitishsh91
    4 years ago

    You can try running R script to create an excel report with data but with that you will have to use Personal gateway or try exploring the Power Automate way.

     

    There is no default way fo exporting via excel only PDF and PPTX are possible.

     

    You can try submitting a new idea if it can be included in future releases.

nitishsh91's avatar
nitishsh91
Icon for Solution Supplier rankSolution Supplier
4 years ago

You will have to create paginated report if you want to have automated delivery of excel file and as you are using premium capacity then this will be the best option.

 

Otherwise you can try exploring Power Automate  to send excel report, I haven't tried it but I think its possible to do.

  • EZimmet's avatar
    EZimmet
    Icon for Resolver I rankResolver I
    4 years ago

    Output size is

    30 Columns x 1845 Rows

     

    Report builder will not create a file this size 

    • nitishsh91's avatar
      nitishsh91
      Icon for Solution Supplier rankSolution Supplier
      4 years ago

      You can try running R script to create an excel report with data but with that you will have to use Personal gateway or try exploring the Power Automate way.

       

      There is no default way fo exporting via excel only PDF and PPTX are possible.

       

      You can try submitting a new idea if it can be included in future releases.