Column sort functionality does not work on Date column in lakehouse GUI
The following issue affects both the lakehouse and its SQL Endpoint GUI.
ISSUE:
Given a DimDate table created with a DFg2, the Date columns in the DF contains dates all the way to 2025-12-31 (for example, as the DF param end date is set to this date). Sort the Date column in descending order and sure enough the last is there, correctly.
After running the DFg2 so that its output is loaded into a lakehouse table named DimDate, open the lakehouse, click on the table name and then use the GUI to sort the Date column in descending order. Make sure the scroll bar of the Y-axis of the viewport is pulled up all the way up.
Result: the first date shown is 2025-06-30 and not 2025-12-31 as should be the case. Same happens when you repeat these steps in the SQL Endpoint GUI.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
About "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf5 hours agoFrequent VisitorNew48Views3likes2CommentsEventstream MQTT broker source: V3.1.1 support
The Eventstream MQTT broker source supports connections with public MQTT brokers that offer MQTT V5 support. Please offer support for V3.1.1 too, because this is still a valid and widely used ver...svelde6 hours agoSuper UserCompleted1.4KViews6likes4CommentsGet data from Apache Kafka topics via private networking
Current prerequisites limit to public Kafka instances which is not feasible for most enterprise customers. When will this limitation be lifted so that it can be used in private network setups, for ...Jugi6 hours agoMicrosoft EmployeePlanned3.5KViews2likes3CommentsSet default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg15 hours agoNew MemberNeeds Votes7.8KViews1154likes104Comments