Forum Discussion

Guy Hunkin's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
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
THOMAS J MUNSON's avatar
THOMAS J MUNSON
Copper Contributor
Dec 12, 2017

Very important, the new 2016 method breaks a lot of web connections for me.  For example, I have a page that I cannot get to without entering a login.  Old way the page opens up I enter login and then check the box to grab the data I want.  If needed clean and transform is used to get rid of unused items.  I was looking for an answer to this issue which brought me here.  Please bring it back.

 

FYI- I have tried the new method by but no luck getting past login page.  It would be nice if I could get that feature to work but no luck yet.

  • Guy Hunkin's avatar
    Guy Hunkin
    Icon for Microsoft rankMicrosoft
    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's avatar
      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's avatar
        Guy Hunkin
        Icon for Microsoft rankMicrosoft
        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

Resources