Forum Discussion

MnMs's avatar
MnMs
New Member
2 years ago

Adding blanc column in power query for future notes

Hello everyone,    I have a power query report, for which I need to add few empty columns so I can manually add notes later on excell.  The data source is an excell file . I tried two methods and...
Need Help
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
2 years ago

You need to add the placeholder columns in Excel. If you add columns in Power Query, then add columns in Excel, the added columns in PQ will not care. They will get added again, and may cause naming conflicts.

 

Other than that I'd need to see some screenshots of the issue. 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.