Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Cheers
I have an excel file in Sharepoint online and I have another excel connected to this path to update the values every time they change.
If I execute the Update data query from Excel on the desktop, it works without incident. the problem is when the user updates it in excel online, since it tells us that it is not possible. microsft recently updated this tool in excel online so queries to sql tables or files in web mode do not work.
how can i correct this?
After re-reading your original post, I now understand what your issue is.
If you can use a Sharepoint List instead of an Excel file, you can easily achieve this using power automate (Link)
thank you for your answer. I am not lying to you when I say that the solution that you indicate me will not be applied, can you explain to me how I could do it. Thanks a lot
If your excel is just a table, try to use Sharepoint List instead of Excel.
This is possible using Power automate flow. You need to upload excel file to SharePoint/OneDrive, then you can read the excel rows using Power automate and then update SharePoint list items.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |