From Online Service Option disable How to enable that in Office 2016

[kirankk91]

I have office 365 i have also installed Power query (64) bit but when I click Get Data under "Data" in excel that time "From Online Services" Option showing disable, How to enable that.

Please suggest Thanks in advance..

[v-yingjl · Accepted solution]

Hi @kirankk91 ,

As far as I know, this feature “From Online Services” is only available to the Office applications with Product Information Microsoft 365 for enterprise.

If you are using Microsoft 365 for business etc., this feature is not available.

See: Excel: Unable to get data from online services 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ehren]

What license/SKU are you running? Please see this page for more info on what Power Query features are available in each version of Office.

https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-...