none
Issue with multiple O365/Power BI accounts

    Question

  • Hi,

    I have several O365/Power BI accounts 
    when I check my Excel it says I am signed in with "Account1"

    When I want to use Power Query (e.g. to share queries, etc.) I need to Sign In first
    the problem is that Power Query always signs in using a different account - lets say "Account2"
    So sharing queries are shared to company of "Account2" even though im signed in to Excel with "Account1"

    I cannot change the account during the Sign In process as Excel thinks that I am signed in with "Account2" already

    any ideas on how i can change this behavior and 
    - sign in with the current O365 account ("Account1" in the scenario above)
    - manually enter credentials for the Power Query Sign In

    any help is highly appreciated!

    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Wednesday, March 26, 2014 1:16 PM

Answers

  • OK, this finally worked:

    1) connect to an OData feed exposed by the new tenant using Power Query OData Source
        e.g. https://<MyTenant>.hybridproxy.powerbi.com/ODataService/v1.0/<myDataSource>

    2) change Authentication to "Organizational Account"

    3) Sign Out if you are signed in with the wrong account

    4) Sign In again with the Account of the new tenant

    now I am official signed in to Power Query with the new Account


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Wednesday, April 02, 2014 11:34 AM

All replies

  • Yes, as you've discovered, the Office sign-in button and the Power Query sign-in button are unrelated at this point. The sign-in that you use for Excel should have no effect on the Power Query sign-in process.

    Now, in order to let you use Account 1 for PQ instead of Account 2... once you're signed in to PQ with Account 2, do you have a Sign Out button in the PQ ribbon? If you click that and then click Sign In again, are you prompted for new credentials? If so then you should be able to enter your Account 1 creds and then your problem is solved.

    If that doesn't work, we'll have to diagnose the problem. To start that process, please let me know what version of Power Query you have. (There's an About button in the Power Query ribbon on the far right.)

    Friday, March 28, 2014 9:05 PM
    Moderator
  • well, the problem is that after clicking the Sign-Out button and signing in again i am not prompted to enter my credentials but i am automatically signed in again with my old "Account2"

    PQ is the latest version 


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com


    Saturday, March 29, 2014 8:12 PM
  • Can you please click the About button in the PQ ribbon and let me know what version you're on?
    Sunday, March 30, 2014 2:17 AM
    Moderator
  • PQ Version is 2.10.3598.81

    and here is another problem - my old O365 incl. Power BI ("Account2") expired yesterday
    my O365 is still running as I am using the subscription from "Account1" 
    however, when i want to sign in to PQ it says that my account is expired and that i need a valid license but I am not getting prompted for credentials!


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com


    Sunday, March 30, 2014 9:07 AM
  • There is a known issue around the user not being completely signed off. We have a fix for this which should be released soon.

    In the meantime you can work around the issue by clearing your cookies in Internet Explorer. Once you do that you should be able to sign in with a different user.

    Thanks.

    -Alejandro (MSFT)

    Monday, March 31, 2014 5:45 PM
  • Hi Alejandro,

    unfortunately clearing my cookies from IE (and also Chrome) did not work - any other suggestions??

    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Tuesday, April 01, 2014 8:12 AM
  • This should hopefully work:

    1. Close Excel and clear your cookies in IE
    2. Go to the Power Query User.zip file. It is stored in %LocalAppData%\Microsoft\Power Query.
    3. Enter User.zip and delete the ClientAccess folder. This folder contains information about who is logged in.
    4. Restart Excel and sign in.

    I hope this helps.

    -Alejandro

    Tuesday, April 01, 2014 6:59 PM
  • Nope, sorry, also didn't work - still not getting prompted for credentials

    I have Office 365 and also Office 2013 installed, both with PQ - maybe this could be an issue?
    are there any similar caches for Office 2013 that may also need to be cleared?


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Wednesday, April 02, 2014 8:14 AM
  • OK, this finally worked:

    1) connect to an OData feed exposed by the new tenant using Power Query OData Source
        e.g. https://<MyTenant>.hybridproxy.powerbi.com/ODataService/v1.0/<myDataSource>

    2) change Authentication to "Organizational Account"

    3) Sign Out if you are signed in with the wrong account

    4) Sign In again with the Account of the new tenant

    now I am official signed in to Power Query with the new Account


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Wednesday, April 02, 2014 11:34 AM