Power BI and multiple organizations - change active organization

[asdruble-lima]

I manage multiple organizations in Adobe Analytics.

When I connect Power BI to Adobe Analytics, I automatically get one organization but I need to change organizations - how do I "unlink" the organization that my account is connected to so I can get the option to choose which one I want?

Logging out of analytics connector, wiping permissions, or deleting the data source account in PowerBI do not fix the issue.

[Pankaj_Sabharwal · Accepted solution]

Hello @asdruble-lima 

Neither Power Bi Service or Power Bi Desktop can take two logins and change between organizations. You have to log out and then log in again with the other email to change it. 

Hope this helps - https://community.powerbi.com/t5/Service/Switching-organisaton-in-the-portal/td-p/2071751

Thanks

[asdruble-lima]

Hi Pankaj,

Thanks for the input! I think I was not so clear.

I want to change my organization in Adobe, not in PowerBI.

Once I connect PowerBI to Adobe Analytics, I want to choose a specific organization to connect to in Adobe. My organization in PowerBI does not matter in this case!

However, the list to choose the org does not show when I connect (but I think it did show me the list the first time I connected).

So how can I "remove this link" between PowerBI and the active org so I can choose a different one?

[edwardg5146728]

Hi @asdruble-lima 

I've had the exact same thing and have managed to get back to the Organization selector. 

It seems that PowerBI can only retain your selection for one email address. So if you sign in with a different address, it forgets your selection for your primary address.

However, you will need to be able to log into another email address with Adobe Analytics access for this to work.

To get there:

1) Go to File > Options & Settings > Data Source Settings. Select Adobe Analytics and click Clear Permissions.
2) Create a new data source for Adobe Analytics. When it asks you to sign in, sign in with another email address. Click Connect to load the Navigator. You can then close it without creating an actual query.
3) Repeat step 1
4) Create a new data source for Adobe Analytics. Now, sign in with your primarty email and you will get the option to select an Organization.

Hope that helps!

Edward