I'm attempting to make an SQL Azure Database connection, however I'm getting the following error:
Unable to retrieve list of databases. Reason: Failed to connect to the server. Reason: The server principal "foo" is not able to access the database "otherfoo" under the current security context.
I'm using the same connection credentials that I have through LINQpad and SSRS. Any ideas why I would be refused through PowerPivot? Are there some Advanced configurations that I should be checking?
Any topic that doesn't fit in elsewhere
2 posts • Page 1 of 1
I personally have never done this, but I don't see any reason why you would be getting this issue. There are no advanced settings that I am aware of. remote connectivity can be a challenge in my experience. I would be trying to find an Azure expert to trouble shoot the problem. You could also try to do this in Power BI desktop and see if you get the same issue.
Who is online
Users browsing this forum: No registered users and 1 guest