Transposing / Pivoting and Keeping Columns Updated

This issue is killing me, and I haven't found any clear resource to help me solve it.

I have a simple table of daily data, with an attached date:

I'm loading this data into PowerBI, and then using the data transformation tool to make the dates the columns and the headers the rows:

However, every new day, I have to go into PowerBI and add the new column to the table:

How do I get PowerPI to just automatically add every day as a new column when it exists in the database?

Regards Geoff