Results 1 to 2 of 2

Thread: Power Query File Suddenly Exploded to very large file size...why?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query File Suddenly Exploded to very large file size...why?

    Iíve been using Power Query (2013) to import several Csv files, process them, run a couple of merges and dump the final tables in worksheets in excel

    None of the files are very large (less than 200 rows). Iím using staging queries to pull in the data and then separate loading queries to output the results after merging and appending.

    Iíve been saving different versions as Iíve been progressing. I just noticed that the file size has exploded from under 1mb to suddenly 44mb.

    Any my idea why? What info is needed to diagnose?

    Thanks

  2. #2
    New Member
    Join Date
    Oct 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query File Suddenly Exploded to very large file size...why?

    Problem seems to be solved.

    I think the file must have been corrupted.

    I solved the problem
    1. Created a new file
    2. Copied all the queries from the old file
    3. Pasted the queries into the new file

    File size is now back down below 1MB

    I had to reformat the output tables in the new file, but not a big deal

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •