How Do You Consolidate Multiple Connections Into One Connection In Power BI Desktop?
When you import multiple tables and/or worksheets from Excel into Power BI Desktop, you end up with one connection per table/worksheet. Thus, if you import twenty tables you will have twenty connections.
The same applies if you were to import multiple tables from a SQL Server database. The problem arises if the source data changes – for example, an Excel workbook may be moved to OneDrive, or you want to switch from your development to your production SQL Server, in readiness for publishing the Power BI Desktop model to PowerBI.com. You must find and update every single connection. Here is a way of having just the one connection, making life simpler and less error prone.