Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
vijayng17
New Member

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

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vstephenmsft_0-1696927969088.png

vstephenmsft_1-1696928114803.png

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.           

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

vstephenmsft_0-1696927969088.png

vstephenmsft_1-1696928114803.png

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
Super User
Super User

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.