Forum Discussion
Scheduled cache refresh issue when using a live connection to SSAS
Has anyone experienced a scheduling issue when using a live connection to SSAS (multidimensional)?
We have an on-premise SSAS instance.
We connect to it via a Power BI on-premises data gateway.
The data source on the gateway has been configured to map user names
i.e. ‘Effective user names’ is configured to replace * with a domain user (e.g. domain123\user123)
This all works 100%. I can publish a report to the service, view it in the service, click on the ‘refresh’ button in the report … no problems.
BUT the ‘schedule cache refresh’ on the dataset fails with the following error : "Unable to connect to the Analysis Services database. Please verify that the database exists, the user account to access this data source has access to the database, and that the database is accessible over the network via an on-prem data gateway"
Here is the strange thing:
If I modify the ‘map user names’ on the gateway data source to instead of using an asterisk(*) to rather use my email address/service login name, then the scheduler works fine. For some reason the scheduler does not like to use the wildcard asterisk(*)
3 Replies
Hi gavindk,
From your description, I could not understand the sentence "If I modify the ‘map user names’ on the gateway data source to instead of using an asterisk(*) to rather use my email address/service login name, then the scheduler works fine. For some reason the scheduler does not like to use the wildcard asterisk(*)" you have post in the topic. Based on my research, when you are using the 'map user function', the original name is your current account name and new name should be your User Principal Name (UPN).
Regards,
Daniel He
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.
