Forum Discussion
Solved
datasource access error to SSAS
I deployed ssas tabular from VS 2017 to Analysis Services 2016 and created a report from PBI Desktop using Live connection which all works great. Published it to a PBI workspace and when trying to ac...
It was resolved by our IT dept. We had corporate domain which was different from our development domain and accorging to them they modified some forwarding settings . And I modified the effective user setting under manage gateway to map the email to an actual domain account.
Hi there
When you go into the Mange Gateways, then the data source. If you click on Users and then Map Usernames, what settings does it have in there?
I think that you are possibly going to have to map it from a UPN to a domain login where it is set to "Effective UserName", so for example if my UPN was [email protected], I would then map it to FOURMOO\Gilbert
When you go into the Mange Gateways, then the data source. If you click on Users and then Map Usernames, what settings does it have in there?
I think that you are possibly going to have to map it from a UPN to a domain login where it is set to "Effective UserName", so for example if my UPN was [email protected], I would then map it to FOURMOO\Gilbert
That didn't solve it. I think the issue might with domain trusts and I am working with IT to try it out. Our logins are on domain A and the SSAS server is on Domain B where there is trust between B and A. I am now trying to add the SSAS machine to the same domain as my login and see if that's the issue. I will update it here with the results once I do that.