Forum Discussion
Scheduled cache refresh issue when using a live connection to SSAS
Hi v-danhe-msft
The 'replace' (original name) = the name you use to sign into Power BI with.
The 'With' = what will be passed to the EffectiveUserName property for the Analysis Services connection.
And this all works fine for me when I put my user name under the 'replace' column. I can publish, view and refresh reports. I can also schedule cache refreshes, which run successfully.
You can also make use of a wildcard (see ‘using wildcard’ in the link you sent https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#manual-user-name-re-mapping )
Using a wildcard you can place an Asterisk under the ‘replace’ column. This will allow you to take all users and pass a single value to the data source. This is useful when you want all users in your organization to use the same user in your local environment.
If I use the wildcard (*) under the ‘replace’ column, everything works fine, except for the schedule of the cache which starts to fail.
Hi v-danhe-msft
I just found the problem. The account we use under the 'With' column is a read only user. Making this user an admin user resolves the issue of the failed schedules. The question now is why does the effective user need admin permission when the cache is refreshed via the scheduler?
For security reasons we can’t allow that.