Forum Discussion
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
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?
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.