How to format the date column for live data connection and also need to replace null values

Hi vijayng17 ,

Sorry, you can‘t change the date format in a live connection. 

However, if you datasource is dataset, you can first change your connection from live connection to DirectQuery. After changed, you can change the date format under column tools in Power BI Desktop.

For live connection data sources, there are more restrictions, which is for security reasons. If you need to modify the column format or replace the values, it is best to modify it in the data source and then connect with the live connection. Or use import connection mode or directquery connection mode.

Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision! - RADACAD

Best Regards,

Stephen Tao

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