Forum Discussion

vishbabariya's avatar
vishbabariya
Regular Visitor
7 months ago
Solved

ODBC Connection to Excel Workbooks

Hello everyone! My Power BI datasource is currently a ODBC connection. I am trying to remove that connection and would like to add excel workbooks as my data source. I keep on running into an error,...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    7 months ago

    Hi vishbabariya - You cannot “remove” an ODBC connection directly if it is still being referenced by Power Query queries, the data model, or parameters.

    To keep the report unchanged and only swap the data source, you must redirect the existing queries, not delete them.

     

    For each table

    Select the query

    Open Advanced Editor

    Replace only the Source = Odbc.DataSource

     

    Please let me know if any more details required.

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
7 months ago

Hi vishbabariya - You cannot “remove” an ODBC connection directly if it is still being referenced by Power Query queries, the data model, or parameters.

To keep the report unchanged and only swap the data source, you must redirect the existing queries, not delete them.

 

For each table

Select the query

Open Advanced Editor

Replace only the Source = Odbc.DataSource

 

Please let me know if any more details required.