Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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.
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.
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:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |