Can I export Sharepoint data as dashboard by Power Automate

(0) Share

Report

Posted on by PannEiSan

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.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

takolota1 4,974 Moderator on at

Like (1)

Report

@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.asp
And then host them as a webpage using a flow like so

https://youtu.be/ePwHNz4laRQ

Was this reply helpful? Yes No
PannEiSan 30 on at

Like (0)

Report

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 .

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
PannEiSan 30 on at

Like (0)

Report

I think, internal.

Was this reply helpful? Yes No
Verified answer

takolota1 4,974 Moderator on at

Like (1)

Report

@PannEiSan

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

Was this reply helpful? Yes No