Before I explain how to fix this, let’s take a look at what’s happening behind the scenes.
When email@example.com opens the dashboard a connection string is created including the effectiveusername property, which is expected behavior.
The value specified for this property is firstname.lastname@example.org.
The connections string including the queries are sent via the On-Premises gateway to the SSAS server that hosts the data needed to view the report.
Once the connection is established, using the username and password specified in the Data Source settings, all queries are executed email@example.com.
Read on for the solution.