change odbc source to Excel

[fscovil]

Hi, am relatively new to the PBI design side of things.  

I have a large report & relatively large semantic model that was originally loaded via odbc query connection.

We've lost access to the odbc database and are now loading it from csv files.  

I'm trying to change the data source from the odbc query to local excel and can't seem to find a way to do it that doesn't completely wipe out the tables created by the original query (we have LOTS of measures & visuals linked to the imported tables)

Can anyone give me some pointers on how to change from an odbc to individually uploaded excel files?  or another alternative

We do analysis of client data so we don't need an ongoing upload, we just need to load each client's data once at the beginning of each engagement.

thanks

[vanessafvg · Accepted solution]

what i usually do is i create a new connection connecting to the new datasource.  I then copy the source lines from advanced editor in power query from the new connection and i replace that in the old connection.  As long as you replace the correct lines and make sure the steps are still linked up.  Its best not to change to much of the naming, keep it the same as much as you can in terms of the steps.    If you copy the new connection source details above all the transformations, there shouldn't be an issue.

[fscovil]

thanks - I'll give it a try.