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

Anything related to PowerPivot and DAX Formuale
MattAllington
Posts: 866
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?
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

h_gp9
Posts: 23
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: 23
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 9 times

MattAllington
Posts: 866
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 Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

h_gp9
Posts: 23
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: 866
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 Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests