Forum Discussion
"Data Source Access Error" one-way transient trust relationships between domains causing problems?
- From powerbi.com, I'm getting the error "There was a data source access error. Please contact contact the gateway administrator"
- When I created the original PBIX file and publish, it reports "Publishing Succeeded. The published report has been configured to use an enterprise gateway"
- The On Premise Data Gateway seems to be setup correctly: "The gateway Model1 is online and ready to be used."
- Note that my user credentials are on one domain (primary company domain), and the server is on a different domain (used for evaluation servers). There is a one-way transient trust between the server domain and the domain being used for user accounts. The user accounts domain does not trust the server's domain. Could this be causing the problem?
What other information can I provide that will shed light on why my published Report cannot access the data source?
gdarmohray,
You would need to set up two way trust relationship between the two domians, or use Map user name feature in Power BI Service.
There is a similar blog for your reference.
http://blogs.adatis.co.uk/ustoldfield/post/One-way-Domain-Trust-and-Power-BI
Regards,
LydiaLydia, Thanks so much for your response. That now makes total sense. I haven't had a chance to try the solution, but the description is most likely the cause of this not working. Having a one-way transient trust relationships between the domains would prevent the authentication from working. Thanks!
2 Replies
gdarmohray,
You would need to set up two way trust relationship between the two domians, or use Map user name feature in Power BI Service.
There is a similar blog for your reference.
http://blogs.adatis.co.uk/ustoldfield/post/One-way-Domain-Trust-and-Power-BI
Regards,
LydiaLydia, Thanks so much for your response. That now makes total sense. I haven't had a chance to try the solution, but the description is most likely the cause of this not working. Having a one-way transient trust relationships between the domains would prevent the authentication from working. Thanks!