We have different values appearing in Power Query on service vs desktop
SOURCE_VALID_TO
When the text is extracted the underlying value is the same
This is the end of a time series date.. so its a bit different from a normal date
The problem is when we put a filter on this date... what should we filter for 1816 or 9999?
It would be good if this can be standardized across service/desktop
If i am missing something obvious here let me know
No CommentsBe the first to comment
Recent ideas
New Advanced Editor hides query name and locks editor window
Classic Power Query 'Advanced editor' opens as a separate movable, resizable window with the query name as its title. One could drag and keep the main editor visible : queries pane, applied steps, d...Mardurolla3 hours agoRegular VisitorNew7Views0likes0CommentsGet Secret from Azure Key Vault using Fabric Workspace Identity
Users can access key vault secrets using notebookutils.credentials.getSecret. This is based purely on the user's access (or object owner's access, if the notebook is being run in a pipeline). In larg...sean_cochran3 hours agoResolver INew3.1KViews14likes3CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...lamogiro3 hours agoNew MemberNew5Views0likes0CommentsPaginated Reports with PowerQuery - Cloud connections for Snowflake connector
Current situation: Power BI report builder used to build a report using Power Query dataset. Report builder picked the right cloud snowflake DB connection (created in Power BI service portal - app...jarjis_nbcu3 hours agoNew MemberNew2Views0likes0CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...Mardurolla3 hours agoRegular VisitorNew8Views0likes0Comments