Forum Discussion
Helper IWhy won't new column added to table show up on PowerQuery?
Hi handwepg,
In the query editor you need to add a column similar to this:
(if [A] = null then 0 else [A]) + (if [B] = null then 0 else [B])
This will give 0 when the A or B column is null and sum result of both columns when you have values on both.
No need to change null to 0.
Regards.
MFelix
Helper IIIHello handwepg
Click on "Edit Queries" and then on "Advanced Editor"
You will see a text restricting maximum number of columns as highlighted below:
In my case it is showing 158 because i have 158 columns in my table. In your case, whtever number you see here, just type one more than that (if its 9, change it to 10). Save query and you are done. your new column will be added.
Cheers
Hello Waseem,
Though you gave a useful information but for my .xlsx file I couldn't see any restriction with the number of columns being exported, it might be applicable for CSV alone or some change might have happened from 2018. But thanks for your information.
- MFelix
Super User
Hi Anonymous ,
Are you missing some columns when importing a .xls file? Did you just updated the source file and the columns aren't showing?
Be aware that if you have the connection to an excel spreadsheet, when you start making your changes the columns you work with are saved on the query steps and you may need to add that column manually to the first step where they get the detail.
This depends off course on the way the setup is made, and how you are making the transformations.
Thanks for your tips MFelix