I edit connection but after: "We couldn't refresh the connection"

Anything related to PowerPivot and DAX Formuale
MattAllington
Posts: 962
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: I edit connection but after: "We couldn't refresh the connection"

Postby MattAllington » Thu Jun 01, 2017 9:07 am

OK, so that confirms that the source is fine. The next thing I would try is to remove the relationships between this table and any other tables. Try to refresh then. Then go back and recreate the relationships (you will need to recreate them anyway I guess). There can be a problem if the table is a lookup table and the refresh forces duplicates on the primary key.

What is the data source you are using? SQL, Excel?


Tap on the link to learn more about my PowerPivot Books.
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
[URL=https://exceleratorbi.com.au/power-bi-online-training/]Power BI Online Training[/URL]

h_gp9
Posts: 26
Joined: Wed Jan 18, 2017 9:50 am

Re: I edit connection but after: "We couldn't refresh the connection"

Postby h_gp9 » Thu Jun 01, 2017 1:18 pm

My data source is an excel file.

h_gp9
Posts: 26
Joined: Wed Jan 18, 2017 9:50 am

Re: I edit connection but after: "We couldn't refresh the connection"

Postby h_gp9 » Sat Jun 10, 2017 6:31 am

I followed those steps:

To change the external data source used by a current connection
1.In the PowerPivot window, click the Home tab, and in the Connections group, click Existing Connections.
2.Select the current database connection and click Edit.
For this example, the Table Import Wizard opens to the page that configures an Access database. However, depending on the type of data source you are changing, the provider might be different, and also the properties that are available.
3.In the Edit Connection dialog box, click Browse to locate another database of the same type but with a different name or location.
As soon as you change the database file, a message appears indicating that you need to save and refresh the tables in order to see the new data.
4.Click Save, and then click Close.
5.On the Home tab, in the Get External Data group, click Refresh, and then click Refresh All.
The tables are refreshed using the new data source, but with the original data selections.

However always get the error attached in excel file
Can you help me?
Thanks in advanced
Attachments
Error message when I change source.xlsx
(540.21 KiB) Downloaded 70 times

MattAllington
Posts: 962
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: I edit connection but after: "We couldn't refresh the connection"

Postby MattAllington » Sat Jun 10, 2017 9:55 pm

Did you remove the relationships as I suggested?
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
[URL=https://exceleratorbi.com.au/power-bi-online-training/]Power BI Online Training[/URL]

h_gp9
Posts: 26
Joined: Wed Jan 18, 2017 9:50 am

Re: I edit connection but after: "We couldn't refresh the connection"

Postby h_gp9 » Wed Jun 14, 2017 7:29 am

Dear Matt:

I don't have relashionships is only a conexion from where take some columns and I need to refresh it with another file having the same estructure but I can't refresh it as you as seen it.

MattAllington
Posts: 962
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: I edit connection but after: "We couldn't refresh the connection"

Postby MattAllington » Wed Jun 14, 2017 10:03 am

Sorry, I can't help any further. It is difficult to help without seeing the problem.
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
[URL=https://exceleratorbi.com.au/power-bi-online-training/]Power BI Online Training[/URL]

CharlesWitte
Posts: 1
Joined: Tue Jul 31, 2018 12:10 pm

Re: I edit connection but after: "We couldn't refresh the connection"

Postby CharlesWitte » Tue Jul 31, 2018 12:15 pm

h_gp9 wrote:This message appear when after to edit the connection I want to refresh data of this connection. "We couldn't refresh the connection. Please go to the skinny vibes phenq review existing connections and verify they connect to the file or server".
Basically I want to do is change the data connection in other workbook preserving my data model of power pivot.


I'm also facing the same problem. Were you able to solve yours? If yes, can you tell me how? I'm stuck with my project right now as the connection is not getting refreshed in my second workbook.


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 7 guests