Power BI Embedded / Analysis Services Dataset Refresh problem

[Norm]

Hi,

We are embedding content in PowerBI for our clients (it's a SSAS application using the App Owns Data model). So that means that if I have a dataset in import mode connected to an On-premise SSAS Tabular datasource, the owner of the dataset is our pbi master account used in our application (for example [email protected]) . If we try to refresh the dataset using scheduled refresh, the refresh fails with an "The user name or password is incorrect" error because the account [email protected] does not exists in the client local active directory.

Is there a way to refresh a SSAS Import Dataset when using PowerBI Embedded? I known that we can use the map user name feature of the datasource in the Power BI Service but there does not seems to be an API to control this list (so that means that each time a client would add a new datasource he would have to contact us to add the new mapping).

Thanks!

Norm

[v-janeyg-msft]

Hi, @Norm 

Yes, it seems difficult. Check the similar case:API method to map user names - Microsoft Power BI Community

Synchronize an on-premises Active Directory with Azure AD 

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.