Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 through an ODBC connection (I believe this is the best way?). I have all the credentials I need to do this.
What I really want is a one way live connection to the data from the server to Power BI, I don't want Power BI updating data on the SQL server under any circumstances. Can anybody recommend a way of doing this?
Any help would be appreciated
Thanks
Solved! Go to Solution.
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,
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
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.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |