[Help] Choosing subscription plan between Microsoft Business standard & Office 365 E3 - E3 developer

[StevenNguyen]

Hi all,

I just started a trial for Microsoft 365 Business Standard to access SharePoint. However, I realized that Power Query in Excel cannot connect to SharePoint and refresh data.

So, I tried looking for another plan that better suits my needs. However, I am unsure whether the highlighted line, 'Excel Power Query and Power Pivot,' in the picture below indicates that I can connect Excel data to SharePoint.

And I see there is an option for the E3 Developer plan, but I am not sure if I can still make a payment for this subscription. As some topic mentioned that the E3 Developer plan is not supported anymore.

[v-tsaipranay · Accepted solution]

Hi @StevenNguyen ,

Thank you for reaching out to the Microsoft Fabric Community.

Based on your question, it seems your inquiry is more related to Microsoft 365 subscription plans, Excel Power Query, and SharePoint integration.

I recommend posting this question on the Microsoft 365 Community or Microsoft Q&A platform, where experts can better assist you with subscription plans and Office app features.

Here are the suggested forums:

Microsoft Community (Subscription & Billing): https://answers.microsoft.com/m365/

Microsoft Q&A (SharePoint & Office Development): https://learn.microsoft.com/answers/topics/microsoft-365.html

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.