You can follow the below workaround,
Open your existing Power BI workbook.
Click on “Edit Queries” icon from the Home menu.
In the Power Query Editor, select each table that you have loaded and click on the “Advanced Editor” icon from the Home menu.
You’ll see something similar to the below Power Query.
Change the first line of it to “BIConnector.Function("<your DSN name>")” and click on “Done”.
Do this for all the tables once it is loaded successfully.