Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm just getting started with Power BI based on a SQL Server database. I've watched a number of videos, including the following which highlights how a date field will get separated into Year, Quarter, Month, Day columns automatically when viewing in a datatable:
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-6a-explore-time-based-data/
Except that doesn't happen at all in my model where I am directly linked to the underlying dataset? I've looked at options and checked that the field is indeed a date field in SQL and in the model, but it refuses to separate when I add a table visualisation?
Any ideas?
Solved! Go to Solution.
@MisterT It doesn't get seperated if you've connected to data source via DirectQuery method. Only when you import it gets seperated.
@MisterT It doesn't get seperated if you've connected to data source via DirectQuery method. Only when you import it gets seperated.
Hi,
please check ur datefiled datatype first. whether it was in date or some other format ...
or
Can u please share ur requirement as image , that will help us to undestand ur prob clearly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |