Forum Discussion

Rsorrentno's avatar
Rsorrentno
New Member
1 year ago

Unable to update Data Source settings

I have a list of Data Sources for multiple SQL Server databases. The server name used in the connection source setting is the short hostname; i.e. server1.

I need to update it to be the FQDN; i.e. server1.domain.com and can do so for ths first entry but when I make the update for the second entry it undoes my first entry.

Anyone else having this issue?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, Rsorrentno 
     Thanks for reaching out to the Microsoft fabric community forum.

    In my test environment, I also tried directly changing the data source. The changes did not cause any issues initially, but once a refresh was involved, it resulted in data structure mismatches.

     

    I recommend creating a new query in Power Query to replace the same query steps. This method is highly effective and safe.

    For more details, please refer to:

    Solved: Unable to Change Data Source from SQL Server to Sn... - Microsoft Fabric Community


    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 year ago

    Hi Rsorrentno ,

    Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

    Should you have any further questions, feel free to reach out.
    Thank you for being a part of the Microsoft Fabric Community Forum!

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi Rsorrentno ,
      Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

      Should you have any further questions, feel free to reach out.
      Thank you for being a part of the Microsoft Fabric Community Forum!

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        1 year ago

        Hi Rsorrentno ,

        We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

        If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
        If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

        Thank you!