Announcements
I would like to export automatically Sharepoint's data as dashboard by power automate.
I knew that it can be done by Power BI but we can't use PowerBI.
So I would like to know whether it can be done by Power Automate.
Any suggestion , please.
@PannEiSan
Usually you can use some Power BI capabilities and share it with others without a lot of licensing. Are you sure it’s not an option?
https://devoworx.net/publish-power-bi-to-web-step-by-step/#:~:text=Publish%20Power%20BI%20to%20web%20allows%20anyone%20with%20a%20web,sign%20in%20to%20Power%20BI.
Otherwise…
What do you mean by dashboard? Can you provide some specifics on what you want?
How much data is involved with this? Less than several hundreds of thousands of rows?
Can you maybe use Excel, pivot tables, & pivot charts?
Or maybe if you are up for some more detailed programming, you could generate html charts
https://www.w3schools.com/ai/ai_chartjs.aspAnd then host them as a webpage using a flow like so
https://youtu.be/ePwHNz4laRQ
Thanks for your reply.
Yes, I can use excel.
I mean dashboard that I want to express as pivot charts or pivot table in excel .
I knew that sharepoint data can be exported as csv or excel by power automate.
I would like to know that output can be expressed as pivot charts or pivot table in excel .
Are the end users internal or external to your org?
Another way of asking, can they pull in data through Power Query, or will you need to push all your data to staging table(s) in a copy of a template Excel file?
I think, internal.
Okay, then you should be able to set up a shared Excel workbook with some tables imported from the SharePoint list using Power Query. Then you can create pivot tables & charts from that.
https://youtu.be/0aeZX1l4JT4?si=f1FeV2t_z1TkA0Jv
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 594
Valantis 328
David_MA 281 Super User 2026 Season 1
