Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

Direct Query Issue

I have a very strange issue, when i connect via the deskop to my server (im am connecting onto another domain, however my environment is set up to allow me to do this) if i use the default method Get...
Need Help
hugoberry's avatar
hugoberry
Icon for Responsive Resident rankResponsive Resident
9 years ago

Try verifying that you use the right user to connect to you SQL server. I've seen instances where Power BI would try to act clever and default to different set of permissions than needed.  Try checking that in the Data Source Settings > Edit Permisions >... the Credentials are set to your desired setup.

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    The credentials are set up correctly as far as i can see,  its only when i go into a native query mode that it wants me to renter details.  I am logging on to another domain which works fine if you dont change the default setting and just put in the server.   But as soon as i write my sql statement, or maybe its when i put in the database that it all goes belly up.

     

    I am busy looking at the trace files, it looks like an issue with the firewall maybe.  I just find it odd that as soon as i put a database name it says the user is not authorised - i have tried to put in alternative credentials but it doesn't authorise it.    I did try switching the native database queries in the settings (require user approval) on and off, makes no difference