Forum Discussion

HasanK's avatar
HasanK
Icon for Helper I rankHelper I
5 years ago

Power Query removes first blank column of the table automatically

I have an issue in Power Query, Weekly reports are comming, each reports first column is BLANK. When I created a query first, Power Query showed this blank column and I defined all steps according t...
Need Help
Show and Tell
Tips and Tricks
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi HasanK ,

 

I found that there is a "remove" step in your top 3 queries.So would you pls check about it?Seems that the remove isnt done automatically.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

HasanK's avatar
HasanK
Icon for Helper I rankHelper I
5 years ago

Yes that step removes some columns including Column1 (normally it must be BLANK one) but BLANK column is not exist therefore it removes Column2 as it is assuming Column1 therefore query is broken...

  • gabotuit2's avatar
    gabotuit2
    Frequent Visitor
    3 years ago

    Hello, did you ever find a solution to this issue?

     

    • HasanK's avatar
      HasanK
      Icon for Helper I rankHelper I
      3 years ago

      Yes I did, I put a character into A1 manually, it is solved.

      Thanks