Forum Discussion

Microsoft

Oct 18, 2016

Importing Data using legacy Web Connector in Excel

Hi all, I have a question related to usage scenarios of the legacy Import from Web connector in Excel. Today the legacy Import from Web connector supports the following features, ...

BI & Data Analytics

power bi

Guy Hunkin

Microsoft

Dec 13, 2017

Hi there,

If you still want to use on of the legacy data import wizards, you can bring them back as described here.

Hope this helps.

Guy

- Excel Team

Tim Scott

Copper Contributor

Dec 13, 2017

Guy,

Thanks for the note on the legacy wizards. This appears to address my issues, but I will need to do some further testing.

Are there plans to remove the legacy wizard capability from a future update?

I was struggling with the comment regarding the legacy wizards being less secure. Could you elaborate, please?

Why can we not have Web.Page() capable of authenticating?

ref: http://email.feedback-poweredby.uservoice.com/c/eJyFkLtuwzAMRb_G3hTQelkePAQo8hsGJdGOEEVybblp_75K0CVTAQ583EuQx48cOoVtGBUK4INQrveGTx1HLyzNCqUBbhRI10g4dtq-cnB0cvneXse5n6G3rheDVFpbN6Dz4KDX3HthSLRxvJay7o04N_xSg74dxdPbmtqd83bc95oIkAPv2EvFapc9QvL5sTNP-63kleG6xuCwhJyqfD-WhfZn8TJ3A4AWgm3EKKGNxPAoV0rlz8EcrmhDDOXntbzO2JoftH024kJ3DHGKeQlpKvlGqREf9TmYuQSNUlRKoC3BAKgdojIOoeG6bOhuIS2Ty56qpTceKy_pO24qDoNS9dJqWSlWQtq3b4bxX_k2Lke0G4ZU8S_PG5_MfgE6RItP

Thanks,

Tim

Guy Hunkin
Microsoft
Dec 26, 2017
Hi Tim,

There are no plans to remove the legacy wizards from Excel. They are just hidden from the ribbon, but you can bring them back if required.

Regarding the "secure" comment, then Power Query supportד various modern ways of authentication - Basic auth, OAuth, Azure Active Directory authentication and more. Some of those are not supported in legacy wizards.

Regarding Web.Page() authentication, then I assume you are talking about Form Authentication, right? Well, if this is the case then the best way to influence will be to vote for this idea on Excel or PowerBI User Voice. This helps וד to prioritize our resources.

Guy

- Excel Team
- Tim Scott
  Copper Contributor
  Dec 26, 2017
  re: Web.Page()
  I mean http basic authentication - as that is what is used to do and it worked very nicely with the http-basic auth I implemented in our application.
  
  I have some votes on the suggestion at: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31900633-re-enable-authentication-capability-for-the-powerq?tracking_code=78da0284d128c9a8a4574b644805666d
  
  Thanks,
  
  Tim
  - Guy Hunkin
    Microsoft
    Dec 26, 2017
    Power Query supports Basic authentication out-of-the-box. Am I missing something?