Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |