2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power Query in web Excel - what exact business plan is needed?

I'm trying to use Power Query in work, but we've only got Microsoft 365 Business Basic licence/plans.

Looking at the Microsoft announcement about the new Power Query experience (https://techcommunity.microsoft.com/blog/excelblog/new-in-excel-for-the-web-the-full-power-query-experience/4472352), it says "Viewing and refreshing queries is available to all Microsoft 365 Subscribers. The full Power Query experience is available to all Microsoft 365 Subscribers with Business or Enterprise plans."

I can't seen to find any documentation about what exact Business plans are included, as I don't think it's working for me due to only have the Business Basic plan.

I can see the Get Data button, but when I click it the button disables and nothing happens. I thought it might have been a browser and/or cache issue, but I've tried on multiple different browsers and computers, and can't get it to work, so I'm thinking it's a licence issue.

Our outsourced IT team are pretty useless at questions like this, and won't ever refer back to Microsoft support so you guys are pretty much my shadow IT team 😆

So my questions are:

  1. Does anyone know what exact/minimum plan is needed?
  2. If I create a Power Query query in my own personal desktop Excel, and then upload that file to the company OneDrive/SharePoint, will the query still be able to be refreshed in web, even if I can't create new queries?
submitted by /u/welshcuriosity
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#business intelligence tools
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#enterprise data management
#big data management in spreadsheets
#enterprise-level spreadsheet solutions
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#big data performance
#data analysis tools
#data cleaning solutions
#Power Query
#Microsoft 365