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

[vijayng17]

Need to format the date column which is coming from Live data connection and direct model and the NULL values should be replaced with "NA" in the visual for the same column

[Anonymous · Accepted solution]

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.           

[Ritaf1983]

Hi @vijayng17 NA is not a date format.
So if you want it the column should be "text".

According to the data type of the column Unfortunately In Power BI Desktop, it is not possible to change the data type for columns when you connect to SSAS using "Connect live" mode. You can change the data type in the SSAS database instead.

Please refer to the linked discussions about the same issue:

https://community.fabric.microsoft.com/t5/Desktop/How-to-convert-a-column-to-quot-date-quot-data-typ...

https://community.fabric.microsoft.com/t5/Desktop/Analysis-Services-Changing-Data-Type/m-p/560885#M2...

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