We have a problem where the USERNAME() is being cached when two users are using power bi embedded at the same time. This has only started happening recently. Its is causing the RLS to break and each ...
Thanks for the reply.
We are able to replicate it now, we are generating a token and passing it to microsoft for embedding the power bi report, but the report is using someone elses token when being viewed.
usually its the token of the person who either last viewed it or viewed it a few minutes ago.
This has only started happening at the end of last week, it is breaking our user based RLS.
Please can it be investigated? Usually takes 2 or 3 refreshes to pick up someone elses credentials
Just to confirm this has been working fine for 3 or 4 years prior to this, however we cant replicate it in the sandbox, only on our system