Problem was solved, in File/Options and setting/Data source settings I edited credentials.
I have a unable to connect screen but a little different. its not really giving me any information as to why its not connecting. literally says -
Unable to connect, We encountered an error while trying to connect. Details: ""
then has the options retry, edit, or cancel.
On a side note, when I opened a blank new worksheet in Excel, went to power query and entered the exact same server name with same credentials, it let me connect and pull the tables that are currently there, which isnt anything but system tables.
so is this a Power BI Desktop issue or am I missing something? Thank you in advance for any help.
~Anthony
