Excel Get and Transform from web not picking up newly added columns










1















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.










share|improve this question


























    1















    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.










    share|improve this question
























      1












      1








      1








      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.










      share|improve this question














      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






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 14 '18 at 18:20









      Bart de BrouwerBart de Brouwer

      214




      214






















          1 Answer
          1






          active

          oldest

          votes


















          2














          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])





          share|improve this answer























          • 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










          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
          );



          );













          draft saved

          draft discarded


















          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









          2














          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])





          share|improve this answer























          • 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















          2














          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])





          share|improve this answer























          • 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













          2












          2








          2







          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])





          share|improve this answer













          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])






          share|improve this answer












          share|improve this answer



          share|improve this answer










          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

















          • 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



















          draft saved

          draft discarded
















































          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.




          draft saved


          draft discarded














          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





















































          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







          這個網誌中的熱門文章

          How to read a connectionString WITH PROVIDER in .NET Core?

          In R, how to develop a multiplot heatmap.2 figure showing key labels successfully

          Museum of Modern and Contemporary Art of Trento and Rovereto