Power Automate upload data to Teams for source of pbix model

[Anonymous]

Does anyone know how can I upload a SharePoint List file to a Teams channel and save as an Excel file in Teams using Power Automate, please?

I have a Power BI Desktop model that has an Excel file as its' source data originating from a SharePoint List, with which I would like to create a Power Automate button for users to update the data in the PBI file, as and when they want to.

Currently it is a manual process (that I'm having to do), to Export to Excel, save to my Desktop as   (owssvr.iqy), open it and Enable, save as xlsx file with the file name (CIR Portal Data Table.xlsx) in to the

Source Data folder >> .

Then, when a user downloads the PBI in Teams, they Refresh to update the PBI file with the most recent data in SharePoint.

[Anonymous]

Hi @Anonymous ,

The issue is related to Power Automate, you may get further help in  Microsoft Power Automate Community - Power Platform Community.

Below are some similar threads or blogs that you may refer to:

Solved: MS Flow: Export Sharepoint list to Excel/CSV than ... - Power Platform Community

File management with Power Automate and Microsoft Teams - nBold

How to use Power Automate in Microsoft Teams - YouTube

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