Multi-Tenancy issue with same extensionDataSourcePath

Question

Hi there,I have a report connecting to a Snowflake database for ClientA deployed to this clients workspace.Clients have seperate DBs and reports use service accounts to control access and parameters to change the DB.From the Desktop i publish the report to ClientB's workspace and configure the dataset credentials using ClientB's service account.This then causes ClientA's report to stop working.It appears that when the extensionDataSourcePath is the same (probably just the ID in the backend as my colleagues report still functions) then the credentials update against it and cause one or the other client reports to stop working.I have tried changing the privacy levels but no luck thereAppreciate any assistancecheersAaron

gregpetrossian · Answer

Hey Aaron,&nbsp;When you check the dataset for Client A's report/workspace is it indeed different credentials from Client B's newly published report/workspace?&nbsp;What is the user permission level in Snowflake for the service accounts?

aaronallsop · Answer

Thanks,The credentials are different across both and after i enter them their respective reports work. So permission levels are not an issue.But once entered for ClientA, ClientB's report will stop working and vice versa.Interestingly, when i change the privacy level for ClientA (e.g. to Private) then open ClientB's Data source credentials it shows the updated privacy setting, even though it's in a different workspace&nbsp;

gregpetrossian · Answer

That is really interesting...&nbsp;&nbsp;Are you using the same Power BI Desktop instance to publish both? Do you sign into the credentials for Client A service account, publish, then sign out on Desktop before moving to Client B or did you close the Power BI program?

aaronallsop · Answer

yes - i publish the same report to both workspaces from the same Desktop instance.I then go into each workspace online and change the data source credentials.I even renamed the report to get a different data set name, published from desktop, changed credentials online but the result was the same

gregpetrossian · Answer

Why don't you try a different Desktop instance when you publish? Open Desktop &gt; sign in to Client A service account, set up credentials, publish, sign out and close. Then rinse and repeat with Client B. Maybe there is something that is being carried over using the same instance...&nbsp;

Forum Discussion

Multi-Tenancy issue with same extensionDataSourcePath

8 Replies

Related content

Power BI Multi-Tenancy

Migrating process to Git Integration with Multi Tenancy

Multi Tenancy

How to dynamically bind datasets for multi-tenancy in Microsoft Fabric?

Averagex issue