Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an Odata connection to Sharepoint Online. The data from a list is displayed in the spreadhseet that is also saved to Sharepoint Online in the same site. I would like to open the Excel file online and click the refresh button to update the Sharepoint list data contained in the file. When I attempt to do so it fails.
Documenation says data sources can be updated. I'd think a data source on the same site would be the easiest. I get the following error
I tried using an APP ID from the Sharepoint site in the data source connection. That didn't seem to work.
How do you get a data source to refresh?
Hi @ComputerHabit ,
Pls check a related blog to solve your issue:
http://www.widriksson.com/access-office-365-list-with-power-bi/
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
I don't have a specific script. I'm using the data refresh capablilites of Excel. The more I read, it may just not be possible. I'm reading that the data refresh abilities is limited to only MSSQL.
I'm reading maybe opening up excel with Flows might work.
The ability to refresh a query from within Excel online can depend on how the administrator has set configurations. Yes, you can do this with Power Automate though. Here is an example.
I'm the tenant admin. How would I ensure Excel Online could refresh Odata?
Here is a good resource that describes requirements based on different scenarios.
Please post screenshots and/or your scripts so we can better assist.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.