none
Power Query cannot sign in...

    Question

  • I want to share my Power Query data to my Power BI for Office 365 preview.

    So I try to "sign in" with my Office 365 account, and I got error message:

     "Sorry! You are not authorized to access the requested page. 401."

    What's happened to it..?


    AsiaMiner, CTO


    Thursday, August 29, 2013 3:05 PM

Answers

  • Hi AsiaMiner,

    Please try logging in using your email address in all lower case. We have a known issue today where mixed-case logins can produce this error.

    Please give this a try and let us know if this unblocks you.

    Matthew

    Thursday, August 29, 2013 3:29 PM

All replies

  • Hi AsiaMiner,

    Please try logging in using your email address in all lower case. We have a known issue today where mixed-case logins can produce this error.

    Please give this a try and let us know if this unblocks you.

    Matthew

    Thursday, August 29, 2013 3:29 PM
  • It's not work. Because if I click "sign in ", it'll login automatically, and there is no way to re-login.

    I try to clean the cache in \AppData\Local\Microsoft\Power Query , however the login window still not show...

     

    AsiaMiner, CTO


    Saturday, August 31, 2013 4:35 AM
  • I use another computer, it works.

    But I still need a way to solve the re-login issue..., thanks...


    AsiaMiner, CTO

    Sunday, September 01, 2013 4:09 PM
  • Hi AsiaMiner,

    In most case, signing out could be done by closing Excel and deleting IE cache (IE setting -> General -> Browsing history -> Delete).

    If frequent switching sign-in user is needed, it will better to leave "Keep me signed in" unchecked.

    Shuyu

    Monday, September 02, 2013 8:12 AM
  • I still can't signin. My login name is spelled with both upper and lower case, I can't change this given that it is set by microsoft when giving me the beta instance.

    I would appreciate some help, I hhave a demo tomorrow.

    Regards,


    Monday, October 21, 2013 6:55 PM
  • Even if your name is in mixed case (as mine is) you can still sign in in all lower case. In fact, you must. I had this problem, and it's how I work around it.

    Cheers


    John

    Tuesday, October 22, 2013 4:36 PM
  • Even if I do use lower case it does not work, it used to, but not anymore. I can login to the Power BI site though but not when using power query.

    I can connect to the odata source, sample data for review is shown in the query editor, BUT when clicking "Done" I need to signin again, and it does not accept my credentials (johndoe@xxxxx.onmicrosoft.com).


    • Edited by E.SWARD Wednesday, October 23, 2013 6:13 PM
    Wednesday, October 23, 2013 10:45 AM