Forum Discussion
adding new column to excel data source
Please refer this
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Anonymous
Does the new column appear in the query editor when refreshed?
The best way to handle Excel data sources IMHO is to create tables within excel (selecting the whole range and use ctrl + t to create the table and giving it a name). You then use this table itself as the source in Power BI. If you add columns or rows to the table, you will be sure Power BI picks them up efficiently.
This has literally saved me so much time and frusteration. Thank you!
"The best way to handle Excel data sources IMHO is to create tables within excel (selecting the whole range and use ctrl + t to create the table and giving it a name). You then use this table itself as the source in Power BI. If you add columns or rows to the table, you will be sure Power BI picks them up efficiently."
I'm assuming this won't work if you already had a report built out with the xcel file in regular spreadsheet form then want to add columns and change it to a "table" format, right?
I don't think that would work. I would first convert it to a table, change the code for the source in the query (the easiest way is to create a new query pointing to the table and then copy/ pasting the source code into the original query. Then add columns.