Search found 17 matches

by h_gp9
Sat Jun 17, 2017 12:53 am
Forum: Power Query
Topic: Identify New Rows, Common Rows and Original Rows
Replies: 6
Views: 759

Re: Identify New Rows, Common Rows and Original Rows

Hi Mitchandsuky:

When I try to run power pivot I get errors that I send to you in as attachment.
Could you help me please? thanks in advanced.
by h_gp9
Wed Jun 14, 2017 7:29 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 726

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

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.
by h_gp9
Sat Jun 10, 2017 6:31 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 726

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

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 t...
by h_gp9
Thu Jun 01, 2017 9:02 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 726

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

In a new workbook is working the connection and no need make "Refresh".
by h_gp9
Thu Jun 01, 2017 8:24 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 726

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

I don't want to lose my structured file because this file is the source of other. That's why I only want to update it.
by h_gp9
Thu Jun 01, 2017 7:36 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 726

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

Dear Matt:
When I run the test it is ok. Doesn't make error in this step.
Occurs error when I need to see the new data and then I push "Refresh"
by h_gp9
Thu Jun 01, 2017 2:24 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 726

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

Dear Matt: Let's assume that you work with pivot table and you want to change the source of data. You must do following steps in excel: Analyze → Change Data Source → Select a table or range and normally push Refresh button and our data has been updated. Now talking about power pivot based on data m...
by h_gp9
Fri May 12, 2017 4:05 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 726

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

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 existing connections and verify they connect to the file or server". Basically I want to do is change the data connection in other workbook pre...
by h_gp9
Thu Mar 30, 2017 4:49 am
Forum: Power Query
Topic: Identify New Rows, Common Rows and Original Rows
Replies: 6
Views: 759

Re: Identify New Rows, Common Rows and Original Rows

I'm sending two txt files "Actual" & "Last" that I want to convert in just one "New". This is that I need: 1.-"Actual" should be the Base and will be complemented with appended rows totally different from "Last" 2.-In the new file mixed "New...

Go to advanced search