Forum Discussion

Copper Contributor

Feb 08, 2023

Power Query Connectors missing?

Trying to do a deeper dive into Power Query through Excel (Get and Transform Data). When I select "From Database," my options are limited. I see only SQL Server, Access, Analysis Service, and SQL Ser...

Iron Contributor

Feb 27, 2023

Hi, TomTomas

You may use a workaround that will hopefully allow you to add the different data connectors.

Go to File > Options > Customize Ribbon > Select 'All Commands' in the left table.

Create a new Tab in the right table, and rename it as per your preferences.

Then while selecting the new Tab, find the desired command (connectors) in the left table. Press Add>> button.

Please let me know if it works for you.

Thanks

Tauqeer

TomTomas

Copper Contributor

Feb 27, 2023

Hi @tauqeer,

Thanks for the response!

Unfortunately, I don't see many of the options in your screen shot (particularly, the ones I don't have). I see the options that I already have.

Sorry!

Tom