Refresh Power Query on Excel Web

[flow12345]

Hi I have an excel file that has multiple queries. The source for the queries are from sharepoint. Everything is working fine for me when i refresh my queries in excel desktop. 

But when i upload this excel file to sharepoint, i have issues with refreshing the queries. 

 I keep getting the following message:
This workbook contains Power Query queries using data sources that can't be refreshed in Excel for the Web

I read somewhere that excel web does not support power query refresh other than Table/Range or OData feeds. So I'm wondering if there's anyway for me to refresh the queries like using Data connector etc. 

I thought uploading my source file to sharepoint will work but sadly it doesnt. 😞

Any help will be appreciated!

[christinepayton]

If you open the Excel file in the desktop app from SharePoint, it should work (it's in the ellipsis menu or toolbar from the web UI - you can choose browser or desktop app). 

But if you want to schedule refresh, I would recommend making a Power BI report/dataset - you can open those in "analyze in Excel" to use them in Excel. That way you won't have to push the refresh button at all. 🙂

[jennratten]

You can get SharePoint list data using OData like this: 

• Open Power BI Desktop > at Home Tab > Click on Get Data > Select OData Feed.
• Type the OData Feed URL for the SharePoint "http://siteurl/_vti_bin/listdata.svc" > Click Connect.
  • ListData.svc provides a way of getting information from a list using REST.
• In Navigator dialog, Select the required list > Click Load.
• You should now find the list fields in Fields section, and you should be ready to build your report from SharePoint list items.