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 

SaiTejaTalasila's avatar
SaiTejaTalasila
Icon for Super User rankSuper User
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