Update an excel file in sharepoint

(0) Share

Report

Posted on by Poma23

Hi all, I'm trying to update an excel file in sharepoint with data from power BI:

But I receive this error after 1 second:

Any idea how to solve it?

Thank you for your help

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report
Hi @Poma23

Here's an excellent article on some steps you can try to solve the problem: MS Flow giving “Graph API is unable to acquire or refresh a lock on the file because it is already locked.” message on excel file | coyleonsharepoint (wordpress.com)

Clear the browser cache.

Do not have the flow in edit mode (this actually can lock the file if you are working on the Excel action)

Do not launch the flow and then, while the flow is running, try to edit the file (editing the flow can lock the excel file if you are working on an excel action causing the running flow to fail)

Turn off the flow

Open the excel file in the excel online, make a change, wait for it to save, (undo the change if appropriate).

Do not have the file selected in a SharePoint list as this can activate the file preview and may cause locking (I only have anecdotal evidence for this one).

Open the excel file in Excel app, make a change, wait for it to save (undo the change if appropriate).

In SharePoint, check the file out, then check the file in.

Delete the file, wait a few seconds and restore the file from the recycle bin.

Check it out again, then check it back in.

Hope it helps!

Ferran

Was this reply helpful? Yes No
Poma23 8 on at

Like (0)

Report

Hi
Thank you for your response but it didn't help.
Now I am trying to take a new approach:
I start to create a HTML table with the data from Power BI. Then I create a file and use the data from the HTML table I have.
Everything is ok but the date format is like the image bellow and I can not change it in my excel file:

I wanted to use the “Convert time zone” but since I get the whole power BI data in my HTML, I don’t know how and where to add “Convert time zone” to my date in the new created file.

I also tried to add my data from power BI column by column in the HTML file to be able to use the “Convert time zone” but I get an error because my data is not in form of array.

Could you pls help me?
thank you

Was this reply helpful? Yes No