Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper I
Helper I

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 to this. Then next week reports came but Power Query does not show first BLANK column any more and tries to process all steps without it and consequently query gets error, because Power query detects BLANK column in 2nd week report. How can it be fixed, I will appriciate...






New Member

For anyone who stumbles onto this thread in the future. You can add a custom column in which you promote the headers of the tables and then expand this column. This way it is not important if some tables have an empty first column and some don't. Since the table headers will be used to append the tables.

Super User
Super User

All you need to do is: on the table with your table column, before you expand the columns, add a columns with the column counts of each table. Then sort that column in descending order. This way, your transform file will apply the transforms to the table with the most columns, and any tables with less columns will still follow this order, and you'll keep all of your columns. 

columns_count = Table.AddColumn(Name of prior step, "Count", each Table.ColumnCount([Transform File]))


Then sort, then expand, all set!



I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!
Helper I
Helper I

Thanks @Fowmy ,

Yes it is but this is automatically sent in this format... Your mean that needs manual touch. Also, it is strange, PowerQuery should not act like that without permission.



Super User
Super User


It is better to format the data in the Excel File as a Table to avoid such things.

Did I answer your question? Mark my post as a solution! and hit thumbs up

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

I realised something, it looks a bug or something... I remembered that I opened the file and delete 29/6/2021 and 30/6/2021 because they were in June, and company sends monthly report end of the month (June), therefore first week of July reports also contained 29 and 30 of June.. I just deleted those two columes, A column still there is but interestingly after this interference Power Query started not to recognise BLANK "A" Column. When I copy the original file, it is ok Power QUery reconises BLANK A Column, but if you interfere the file some how, query is broken  

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,

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

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...

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


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


Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors