How to change a powerpivot table "Connection"

[AmitM]

Hi,
I imported data located in 2010 SharePoint site and used it with Power Query to create reports.
Recently, my team switched to 2013 SharePoint site and they stopped adding items to the 2010 site.
How can I change the connection to import the same table from 2010 SharePoint site to the 2013 one?
Thanks

 

[ImkeF]

Well - you need to switch the URL code of your imports. Not actually sure where your problem lies: How to get these or how to pass them to your query
?

 

[AmitM]

Well - you need to switch the URL code of your imports. Not actually sure where your problem lies: How to get these or how to pass them to your query
?

The problem is that once I paste the new URL, the connection is broken --> the table doesn't switch to be importing data from the new link.

 

[ImkeF]

What does the error message actually say?

 

[AmitM]

What does the error message actually say?

You know what- maybe you can guide me how you think I need to address it and I'll follow your steps, then return to you with all the data you need....

Thx!

 

[ImkeF]

?
Have a look here:
https://social.technet.microsoft.co...located-on-a-sharepoint-site?forum=powerquery