cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

analyze in excel - RLS with Multiple Accounts

I'm having trouble changing accounts using Analyze in Excel with Power BI.

 

When I first establish a connection, it asks for user credentials and then successfully uses those credentials for RLS.

However, when I want to change the user as directed in the blog:

 

You can also select Profile from the Power BI ribbon tab in Excel, which identifies which account you're currently logged in with, and provides a link that lets you sign out (and subsequently, sign in with a different account).

 

Excel connects, tells me I'm using the new user, but RLS continues to  use the original credentials.

Is this a bug, are are we doing something wrong?

 

Stan

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: analyze in excel - RLS with Multiple Accounts

Hi @SHHargrove,

 

I have reproduce the same issue on my environment. I will confirm with the Product Team to see if it is known limitation currently, or it is an issue that need to be fixed. And I will post back if I get any feedback. Smiley Happy

 

Regards

Highlighted
Regular Visitor

Re: analyze in excel - RLS with Multiple Accounts

Hi Stan,

 

This is the expected behavior when trying to access shared dataset from two different users and this is the situation here when you changed the user in Excel and then you tried to access the same dataset in Power BI.
The reason is that the library that makes the connection between Excel and Power BI use connection information from the cache to establish the connection that means it connect with the previous user credentials.
You can use one of the following to work around this behavior –
1. Close Excel and delete the cache file from your machine (C:\Users\{user}\AppData\Local\aadmsolapcache.dat)
2. Add the required user mail to the connection string – after sign out and sign in from the Power BI ribbon, go to Data menu , Queries & Connections, Connections, Connection Properties dialog, Definition tab and add the string: User id=<user mail>; in the beginning of the Connection string.

Sagi 

 

Highlighted
Advocate II
Advocate II

Re: analyze in excel - RLS with Multiple Accounts

This may be the "expected" behavior, but not the documented behavior.

Puts a pretty big technical burden on our user community.

Can we get it changed?

Highlighted
Helper I
Helper I

Re: analyze in excel - RLS with Multiple Accounts

Still not "documented" 3+ years later, but the top secret undocumented location of the saved credentials for Excel to connect to the Power BI service (until they change it again) is:

 

%userprofile%\AppData\Roaming\Microsoft\Protect

 

Delete that entire folder, and the next time you open Excel, you'll be asked to log in to Power BI again. It also clears a saved login if you're using OneDrive to sync with Windows, but whatever. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors