Notifications
Announcements
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
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)
Hope it helps!
Ferran
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
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 462 Super User 2025 Season 2
Tomac 456 Moderator
abm abm 243 Most Valuable Professional