Forum Discussion
Power BI Not picking up additional column in Excel data source
Hi I've added an additional columm to the Excel spreadsheet that is my data source, but Power BI isn't (automatically) picking this up when the data is refreshed - viewing the table in Power Query d...
Dear ,
1- In your excel , define the data into table and give the table a name ( in Table Design then Table Name ) , in this way everytime you insert a newcolumn it will be included in the table ,
2- check the new column if it is included in the table
3- check in Power Queries in the applied steps if you made remove other columns .
4- Check for error in the table load from the source
Regards,
Kindly accept as a solution and a kudo if it works with you