Power Platform Community Forum Thread Details

I have excel workbook in my sharepoint that is link to my power BI. In my excel workbook, there is two worksheet called "comment" and "main". i would like to update/copy the data in my power BI into the "comment" tab of the same excel workbook respectively. To update which excel sheet is based on the "Folder Path" + Source.name in my data in power BI. Note to only use one folderpath +source name to locate and know which excel file am i referring to as there is one for each row but i dont want to export every row of folderpath + source name it is to just locate which excel file as it changes based on what the user filter.

Categories:

Power Query

@CU31070624-1

Solution Outline

1. Power BI Setup

Ensure your Power BI model includes:
- A table with Folder Path and Source.Name.
- A filter or slicer that allows the user to select one file.
- The data you want to export to Excel (e.g., a table or visual containing comments).

2. Export Logic

Power BI does not natively write back to Excel or SharePoint. So, you’ll need to use Power Automate or a custom script to handle the export.

🔄 Option A: Power Automate Flow

You can create a Power Automate flow that:

Triggers when a button is clicked in Power BI (via Power Automate visual).
Reads the selected Folder Path + Source.Name from Power BI.
Locates the Excel file in SharePoint using that path.
Clears and writes the new data into the "comment" worksheet.

This requires the Power BI data to be passed into Power Automate using parameters.

🛠️ Option B: Python Script (Manual or Scheduled)

If you're okay with a manual or scheduled process, a Python script using pandas and openpyxl (or xlwings) can:

Read the filtered data from Power BI (exported as CSV or via API).
Identify the correct Excel file using the selected Folder Path + Source.Name.
Open the Excel file from SharePoint (via OneDrive sync or SharePoint API).
Replace the "comment" worksheet with the new data.

📌 Key Considerations

Only one file should be selected at a time in Power BI (enforce with a slicer or filter).
Write access to the Excel file is required.
If using Power Automate, ensure the Excel file is closed (not locked by another user).

🏷️ Tag me if you have any further questions or if the issue persists.

✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.

❤️ Give it a Like if you found the approach useful in any way.