Forum Discussion

Parks_Girl's avatar
Parks_Girl
New Member
2 years ago
Solved

New column from Excel connected to PowerBI Report

I have a PowerBI report on the online service that is connect to an Excel spreadsheet on SharePoint.  I needed to add a column in the Excel spreadsheet to collect additional data.  I want to reflect ...
Need Help
  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    2 years ago

    Hi Parks_Girl ,

     

    Please watch this -

    https://youtu.be/7oiTqK47__c?si=t14UiF1HqtqZdXNZ

     

    Open transform data and import that table again and open advanced editor and you need to copy few lines of the query.Then select your old table in advanced editor and replace those lines in that query.

     

    Let me know incase if you have any issues.And I hope it will be helpful.

     

    Thanks,

    Sai Teja 

mohitkumawat's avatar
mohitkumawat
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hi Parks_Girl ,

Step 1:- Delete the Existing Excel spreadsheet Table From Power Query Transform Data
Step 2 :- Re-Load Existing Excel spreadsheet in the Power Query.
Step3 :- Now you will see all update columns.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!