Forum Discussion
Index column breaks Gateway refresh
I have built a very basic model, and added Index columns to my dimension tables to allow me to replace descriptive text fields in my data table with simple integer fields. Refresh in Desktop works n...
User might not understand deleting the fifth argument so I am giving below what I had and What I changed and it worked for the refresh. May be it is time to update the Onpremise Gateway. :)) I am afraid I forgot the password and stuff. :))
Before:
= Table.AddIndexColumn(#"Changed Type", "Index.1", 1, 1, Int64.Type)
After:
= Table.AddIndexColumn(Source, "Index", 1, 1)
Hope it helps!
Sorry I tried to recreate the problem so the new Index.1 column got added. Use as below.
Before:
= Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type)
After:
= Table.AddIndexColumn(Source, "Index", 1, 1)