Power BI move Data Model to new connection

actsoft
actsoft used Ask the Experts™
on
I have a Power Pivot Data Model that contains 17 tables from multiple databases.
Each table has multiple related and other formulas in them.

The current connection is no longer working. I need to create a new one.
Is it possible to create a new connection and move this Data Model in it's entirety to it?

The table properties does not allow me to change the connection name as shown in the attachment.
screen-shot-table-connection.docx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ryan McCauleySenior Data Architect

Commented:
There are two different ways to view your queries in Excel and it causes some confusion - they both offer different functionality. Here's a walkthrough on changing a data source for an existing connection:

https://support.office.com/en-us/article/make-changes-to-an-existing-data-source-in-power-pivot-9cb508d3-1a83-4d83-a944-700ce41332b6

It looks like you're in the Power Pivot interface, which doesn't let you modify the data source since it's just your data model itself. If you want to change the location of your source data, you either have to change the Excel workbook connection (the link above) or you have to go into the Power Query interface (the "Get Data" screen) and modify the first step of your import workflow there (which links to the data source).

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial