Forum Discussion
PowerBI report - changing Data source from an ODBC to a SQL Server connection, best way?
We have had PowerBI for a while, however it was orginally setup using a personal gateway and an ODBC connection. We are moving to a On Premise Gateway, and a SQL Server connection. Now trying ...
pennyjl Couple different approaches to this. If your queries essentially hard-coded the ODBC connection, you will want to go into Advanced Editor and replace your Source and probably Navigation steps to connect to your SQL Server. You would need to do that per query.
The better approach is if you have a separate query for your data source connection and that's all it does. And every other query simply references that query. Then you only need to do the edit in a single place.
So, essentially, I would create a query that connects to the SQL Server and database only. Copy the relevant lines in Advanced Editor and then edit your other queries as necessary replacing the necessary connection lines.