Replace "1753" default SQL date value in all tables

[Medmbchr]

Hi,

I am working on a PBI dashboard with data imported from a SQL Db. The issue iam having is that each time a date value is empty, it's filled with a 01/01/1753 value.

I'd like to replace this values in all my columns in all table with empty value, that a lot of columns as I have 40 tables with avg of 40 columns each

Is there a way to do this batch replacement in PowerQuery?

Thanks!

[v-yanjiang-msft]

Hi @Medmbchr ,

I think you can do it for all columns in the same table in one step.

First, select the first column, then hold down the shift key while selecting the last column. In this way, all columns are selected. Last, click Transform>Replace Values.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Medmbchr]

Hi

It helps, thanks! However, I need to do a bulk replace to all my tables. I have more than 30 tables.

Rgds,

[v-yanjiang-msft]

Hi @Medmbchr ,

I'm afraid you need to do it one table by one table. We can't select all columns of all tables at the same time.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.