Problem Data source access error although setup gateway successfully

[tama9k9]

Hi everyone, 

I have a problem when working with data source in PowerBI Service. When I publish my report in PowerBI Desktop to PowerBI Service, there's always the problem like the image below. I use the database from Analysis Service to make report in PowerBI Desktop 

The error:

I really don't understand why I still meet the same problem, although I set up the gateway connection successfully like the image below. For the powerbi service and powerbi desktop, I use the same account (my school account) to log in so I don't think it related to my account.

I've been searching the result on the internet and see that there're lots of people meet the same problem as me but only few people can solve the problem 😞

Please help me to fix this. Thank you so much.

[bcdobbs · Accepted solution]

One solution if it's on a local desktop and you're testing is to map the o365 account to local account manually in the gateway config:

There are better ways to do it at scale (lots on it from guy in a cube) but needs working with active directory guys.

[v-xiaoyan-msft · Accepted solution]

Hi @tama9k9 ,

Each time a user interacts with a report connected to Analysis Services, the effective user name is passed to the gateway and then passed on to your on-premises Analysis Services server.

The email address that you use to sign in to Power BI is passed to Analysis Services as the effective user. It's passed in the connection property EffectiveUserName.

The email address must match a defined user principal name (UPN) within the local Active Directory domain. The UPN is a property of an Active Directory account. The Windows account must be present in an Analysis Services role. If a match can't be found in Active Directory, the sign-in isn't successful.

To solve this problem, as bcdobbs mentioned above,you should map user.

Here is an article about how and why you need map user in details, Manage your data source - Analysis Services 

Hope it helps,

Community Support Team _ Caitlyn

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

[tama9k9]

Thank you so much for your support. There're many things I've never heard 😂😂😂

[bcdobbs]

Hi,

Have you watched this video:

https://m.youtube.com/watch?v=GPf0YS-Xbyo

Might help as a starting point.

I also wondered about how local authentication was configured in you analysis service. Eg are you using an AD account or a local machine account? If the later I suspect the gateway is passing through your o365 account and then being blocked.

[bcdobbs · Accepted solution]

One solution if it's on a local desktop and you're testing is to map the o365 account to local account manually in the gateway config:

There are better ways to do it at scale (lots on it from guy in a cube) but needs working with active directory guys.

[tama9k9]

Thank you so much for your detailed instruction. I will try it now.