Forum Discussion
Keep added columns in the table loaded from a query updated weekly
I am using power query to transform the data from a shipment report for reporting purpose. I created a query from the report and loaded the query to a table in the worksheet. I then added two columns...
v-juanli-msft
Community Support
Community SupportHi Anonymous
Do you have data in excel, then you add two columns in excel sheet table for notes?
Everyweek, new data is added row by row in the original excel sheets, you click on "refresh" button from Power BI Desktop to get new data into Power BI, right?
Your issue is : after updates, the two added columns for notes is missing in Power BI?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.