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