connect to ssas direct connection from powerbi - gateway issue

[rkapukaya]

Hi,
i am new at connect ssas tabular model via powerbi directquery. After i created report on desktop, published it. And i configured datasource.
Yet report takes error; "There was a data source access error. Please contact the gateway administrator."

Here is what i do step by step;

* I created tabular model project in import mode and deployed it successfully. I used sql server auth. user to pull data from sql server database.
* I created report on powerbi desktop with my ssas model. And connected to ssas with windows account credentials (readuser@mycompany.com)
this user has server admin privileges on ssas db. Also has rights to login my source sql server database.
* My on-prem gateway is configured by windows account (pbiuser@mycompany.com)
- This user has no rights to login database and analysis services database. User has licence powerbi pro licence.
* I created datasource on web under my gateway connection. And mapped this datasource with my report.
- connection type: analysis services
- user : mycompany\readuser

I login powerbi with pbiuser@mycompany user and get gateway error i mentioned above.When i checked datasource it is successfull. But report takes error and no data shows up.

What are the steps to manage this situation?

[v-deddai1-msft · Accepted solution]

Hi @rkapukaya ,

First check if the windows account you use in powerbi desktop is the same as account you used in power bi service when create credential in manage gateway.

The pbiuser@mycompany.com account that you use to login power bi service should have rights to login database and analysis services database, otherwise, you should map it to the user that have rights to login database and analysis services database.

As mentioned in https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas#manual...   For Analysis Services data sources, you can configure custom UPN rules. Custom rules help you if your Power BI service sign-in names don't match your local directory UPN. 

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

Best Regards,

Dedmon Dai

[amitchandak]

@rkapukaya , refer if these can help in Troubleshoot gateway. I am assuming the issue is faced at power service

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk