Forum Discussion

Maanik's avatar
Maanik
New Member
2 years ago

How to export power bi report to SharePoint automatically every week as a Excel Format

I want to export power bi report to my SharePoint folder automatically every week of Monday and it should be a Excel format and the report is having Table visual and matrix table visual only. So I have tried many a ways but still getting error in run a query against a dataset in power automate so please write your suggestions will help me to resolve this✨🫡

Show and Tell
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Maanik ,

    For paginated reports:
    You can implement automatically sending report data to SharePoint as an Excel file on a weekly basis by subscribing to the report.


    However, for the report:
    Currently there is no support for automatically exporting report visual data in Excel format.


    For this feature it is recommended that you submit this idea, then ask your colleagues to raise up the votes.
    Our product team has direct visibility of these ideas, and they will implement it on the basis of the highest number of votes received.
    Microsoft Fabric Ideas

     

    Best Regards,

    Dengliang Li

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.