Forum Discussion

Sham_24's avatar
Sham_24
Frequent Visitor
2 years ago
Solved

changing sql server connection for Direct Query

I am new to Power BI. I am trying to change my SQL server data source connection to different SQL server data source connection in Direct Query mode. It is asking me to change it to import mode to do...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Sham_24 

    To change a SQL Server data source in DirectQuery mode without switching to import mode, in the Data Source Settings window, locate the current SQL Server data source, and then select Change Feed.

    Enter the details of the new SQL Server you want to connect to, including the server name and database. Confirm the changes and close the Data Source Settings window.

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Sham_24 

To change a SQL Server data source in DirectQuery mode without switching to import mode, in the Data Source Settings window, locate the current SQL Server data source, and then select Change Feed.

Enter the details of the new SQL Server you want to connect to, including the server name and database. Confirm the changes and close the Data Source Settings window.

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

  • Sham_24's avatar
    Sham_24
    Frequent Visitor
    2 years ago

    Thanks YongKang Hua. It worked beautifully.