Forum Discussion

MarkCam's avatar
MarkCam
Frequent Visitor
4 years ago

Unable to connect to the data source undefined

Hi All   i need some help please, im getting the below error msg when i want to refresh my Dataset, i have updated my Gateways to the latest versions and Password are all in sync and security level...
Need Help
MarkCam's avatar
MarkCam
Frequent Visitor
4 years ago

it keeps on asking me to connect to a gateway, i have changed the source in desktop to Azured Sql Server as well.

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Hi MarkCam 


    Can you change the database connection to be "databasename.database.windows.net"

     

    Once that is done Power BI will see that as an Azure Service and allow it to then connect directly.

    • MarkCam's avatar
      MarkCam
      Frequent Visitor
      4 years ago

      Hi GilbertQ 

       

      I have looked everywhere cant see a way to change the DB Connection.

       

      Regards

      • GilbertQ's avatar
        GilbertQ
        Super User
        4 years ago

        Hi MarkCam 

         

        THis would be the server name where you would change it?