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.
Hi All,
I am importing data from SQL Server table, the date is in the MM/DD/YYYY Format. When I add it to the report it by default is loading as YEAR,qtr,month and day. Is there a way where it can just load as date insted?
Thanks
Solved! Go to Solution.
You can change the behaviour of the date field by right clicking on the Date field when in the build pane and select date instead of date hierarchy.
Proud to be a Super User! | |
It sounds like your reporting tool is automatically interpreting the date field from your SQL Server table and breaking it down into separate components like year, quarter, month, and day. To load the date as a single unit instead of breaking it down into its hierarchical components, you can follow these steps:
Format Date in SQL Query: When fetching data from your SQL Server table, format the date field to be in a format that the reporting tool recognizes as a single date unit. For example, you can use the SQL CONVERT() function to format the date in a standard format like YYYY-MM-DD.
Adjust Reporting Tool Settings: Check the settings or preferences in your reporting tool to see if there's an option to treat the date field as a single unit instead of breaking it down into components. Look for options related to date formatting, data types, or default behavior when loading date fields.
Explicitly Specify Date Field Type: If your reporting tool allows it, explicitly specify that the field from your SQL query is a date type. This can sometimes override the default behavior of breaking down the date into hierarchical components. Read more
You can change the behaviour of the date field by right clicking on the Date field when in the build pane and select date instead of date hierarchy.
Proud to be a Super User! | |
Thanks that fixed it.
Ok dear
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 |
---|---|
108 | |
106 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |