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 both did not work.

 

First method

I added custom columns in Power Query , and added my comments on these columns in excell, However when  refresh the query , the commnets on the "Notes columns" disapear, 

 

It looks Like the empty columns from Power Query override the data that I enetered.

 

Second method

I removed the notes columns from power query, (saved and closed), and added "my notes columns" the excell table .

added my notes.

I noticed when I refresh the query that my comments on the "notes columns" do not match the data that I enetered the comments for .

 

for example:  I added a comment on cell M22 for the employee John, after I refresh the same comments moves to aother employees row .

 

 

I wonder , If there is a different way to add these columns in power query and still have the ability to add and keep my comments .

 

Need Help

1 Reply

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