Excel Get and Transform from web not picking up newly added columns
I'm using a Power Query to load in data from a Google Spreadsheet changelog capturing changes by a department within our orginisation.
I set it up using the method of loading the data in via CSV. I generated a download of the sheet from the file I want to use and use the download link to offer a webquery. This was all working as intended. For purposes of my analysis, I had to add two more columns to this sheet and thus the CSV file.
Now, when I run the query based on the link, the new columns (7 and 8) are not being recognised in the query. If I manually set the source to 8 columns, the data that is in there does not show as well.
I've checked the downloaded CSV (which generates the link). It does contain the data in Notepad and it does pickup the data as well when I load in the downloaded CSV into Power Query.
It's like there's some kind of cache limiting the link to the 6 columns previously used, but I've got no clue how to work around it.
Any help to point me in the right direction is appreciated.
excel csv google-sheets powerquery
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
add a comment |
I'm using a Power Query to load in data from a Google Spreadsheet changelog capturing changes by a department within our orginisation.
I set it up using the method of loading the data in via CSV. I generated a download of the sheet from the file I want to use and use the download link to offer a webquery. This was all working as intended. For purposes of my analysis, I had to add two more columns to this sheet and thus the CSV file.
Now, when I run the query based on the link, the new columns (7 and 8) are not being recognised in the query. If I manually set the source to 8 columns, the data that is in there does not show as well.
I've checked the downloaded CSV (which generates the link). It does contain the data in Notepad and it does pickup the data as well when I load in the downloaded CSV into Power Query.
It's like there's some kind of cache limiting the link to the 6 columns previously used, but I've got no clue how to work around it.
Any help to point me in the right direction is appreciated.
excel csv google-sheets powerquery
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
add a comment |
I'm using a Power Query to load in data from a Google Spreadsheet changelog capturing changes by a department within our orginisation.
I set it up using the method of loading the data in via CSV. I generated a download of the sheet from the file I want to use and use the download link to offer a webquery. This was all working as intended. For purposes of my analysis, I had to add two more columns to this sheet and thus the CSV file.
Now, when I run the query based on the link, the new columns (7 and 8) are not being recognised in the query. If I manually set the source to 8 columns, the data that is in there does not show as well.
I've checked the downloaded CSV (which generates the link). It does contain the data in Notepad and it does pickup the data as well when I load in the downloaded CSV into Power Query.
It's like there's some kind of cache limiting the link to the 6 columns previously used, but I've got no clue how to work around it.
Any help to point me in the right direction is appreciated.
excel csv google-sheets powerquery
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
I'm using a Power Query to load in data from a Google Spreadsheet changelog capturing changes by a department within our orginisation.
I set it up using the method of loading the data in via CSV. I generated a download of the sheet from the file I want to use and use the download link to offer a webquery. This was all working as intended. For purposes of my analysis, I had to add two more columns to this sheet and thus the CSV file.
Now, when I run the query based on the link, the new columns (7 and 8) are not being recognised in the query. If I manually set the source to 8 columns, the data that is in there does not show as well.
I've checked the downloaded CSV (which generates the link). It does contain the data in Notepad and it does pickup the data as well when I load in the downloaded CSV into Power Query.
It's like there's some kind of cache limiting the link to the 6 columns previously used, but I've got no clue how to work around it.
Any help to point me in the right direction is appreciated.
excel csv google-sheets powerquery
excel csv google-sheets powerquery
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
asked Nov 14 '18 at 18:20
Bart de BrouwerBart de Brouwer
214
214
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Look for code similar to
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None])
and remove the
, Columns=6
part so that you get
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None])
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
This worked, I set it to Columns=8 at first, which didn't do anything. Removing the Columns=x however did though. Thank you.
– Bart de Brouwer
Nov 14 '18 at 20:39
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53306513%2fexcel-get-and-transform-from-web-not-picking-up-newly-added-columns%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Look for code similar to
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None])
and remove the
, Columns=6
part so that you get
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None])
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
This worked, I set it to Columns=8 at first, which didn't do anything. Removing the Columns=x however did though. Thank you.
– Bart de Brouwer
Nov 14 '18 at 20:39
add a comment |
Look for code similar to
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None])
and remove the
, Columns=6
part so that you get
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None])
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
This worked, I set it to Columns=8 at first, which didn't do anything. Removing the Columns=x however did though. Thank you.
– Bart de Brouwer
Nov 14 '18 at 20:39
add a comment |
Look for code similar to
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None])
and remove the
, Columns=6
part so that you get
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None])
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
Look for code similar to
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None])
and remove the
, Columns=6
part so that you get
Source = Csv.Document(File.Contents("C:TEMP5.csv"),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None])
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
answered Nov 14 '18 at 19:12
horseyridehorseyride
30615
30615
This worked, I set it to Columns=8 at first, which didn't do anything. Removing the Columns=x however did though. Thank you.
– Bart de Brouwer
Nov 14 '18 at 20:39
add a comment |
This worked, I set it to Columns=8 at first, which didn't do anything. Removing the Columns=x however did though. Thank you.
– Bart de Brouwer
Nov 14 '18 at 20:39
This worked, I set it to Columns=8 at first, which didn't do anything. Removing the Columns=x however did though. Thank you.
– Bart de Brouwer
Nov 14 '18 at 20:39
This worked, I set it to Columns=8 at first, which didn't do anything. Removing the Columns=x however did though. Thank you.
– Bart de Brouwer
Nov 14 '18 at 20:39
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53306513%2fexcel-get-and-transform-from-web-not-picking-up-newly-added-columns%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
