Forum Discussion

tj200's avatar
tj200
New Member
8 years ago
Solved

Connecting data to Power BI

Hi,   I am relatively new to Power BI and have a bit of IT knowledge but not very extensive when it comes to SQL server and ODBC connections.   I know I can connect Power BI to an SQL Server thro...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I would not use ODBC to connect to a Microsoft SQL Server. I would use the SQL Server connector instead and it has an option for Direct Query (Live) connection.

  • Anonymous's avatar
    Anonymous
    8 years ago

    tj200,

    It is one way connection, in other words, when you change data in Power BI, it will not update source data of SQL Server database. 

    Regards,
    Lydia

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

I would not use ODBC to connect to a Microsoft SQL Server. I would use the SQL Server connector instead and it has an option for Direct Query (Live) connection.

  • tj200's avatar
    tj200
    New Member
    8 years ago

    Hi Greg,

     

    Thank you for replying. Using the SQL Server connector is it a one way (read only) connection? I really don't want to be able to update the servers data from Power BI. Or is it not possible to only have a one way connection?

     

    Thanks 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      tj200,

      It is one way connection, in other words, when you change data in Power BI, it will not update source data of SQL Server database. 

      Regards,
      Lydia