Enable SQL query in Lookup activity GUI
Is there a way, after pointing a pipeline Lookup activity to a lakehouse, to actually query said LH to get back a singleton? For ex: let's say you have a column named INDEX. You want to lookup the maximum INDEX value currently stored in said column. Can you specify the following SQL query?
...LAKEHOUSE::SQL ENDPOINT::Show stored procedure code when clicking on it in Explorer
Show the code of a stored procedure in a new SQL query tab (if the original tab has been closed) when the user clicks on it in the Explorer tree hierarchy.
BUG::STRING INTERPOLATION BROKEN IN PL EXPRESSION EDITOR
Please fix this:
https://community.fabric.microsoft.com/t5/General-Discussion/BUG-PIPELINE-EXPRESSION-BUILDER-INTERPOLATION/m-p/3843148/highlight/true#M6484
LAKEHOUSE::BINARY COLUMN
Please fix this:
https://community.fabric.microsoft.com/t5/General-Discussion/QUESTION-LAKEHOUSE-BINARY-COLUMN/m-p/3863416/highlight/true#M6871
PIPELINE::COPY DATA::MAPPING::DATETIMEOFFSET FORMAT
Please fix this:
https://community.fabric.microsoft.com/t5/General-Discussion/QUESTION-PIPELINE-COPY-DATA-MAPPING-DATETIMEOFFSET-FORMAT/m-p/3866494/highlight/true#M6915
PIPELINE::COPY DATA::JSON OUTPUT LOSING KEY:VALUE PAIR
If rowsCopied <> 0, then the key rowsCopied will be in the JSON output of the Copy data activity.
If rowsCopied == 0, then the key rowsCopied will NOT be in the JSON output of the Copy data activity.
Why is this an issue? Because if downstream you use a Teams activi...
BUG::DATE SLICERS::FILTER PROPAGATION BROKEN
Please fix:
https://community.fabric.microsoft.com/t5/Desktop/BUG-DATE-SLICERS-FILTER-PROPAGATION-BROKEN/m-p/3863333/highlight/true#M1245099
UX CHANGE TO POWER QUERY RE TIME TYPE AND PUBLISHING TO LAKEHOUSE
All explained here with a screenshot, which I can't insert in this editor (perhaps at some point someone should start thinking of updating the edit functionality on this Ideas site to match those of the Fabric fora).
https://community.fabric.microsoft.com/t5/Dataflows/IDEA-DAT...
IDEA::DATAFLOW GEN2::SEMANTIC MODEL::ALLOW INCLUSION
Please see here:
https://community.fabric.microsoft.com/t5/Dataflows/IDEA-DATAFLOW-GEN2-SEMANTIC-MODEL-ALLOW-INCLUSION/m-p/3876347/highlight/true#M2822
BUG::PIPELINE::EXPRESSION BUILDER::STRING INTERPOLATION IS BROKEN
0__drop a Teams activity onto the design surface. 1__in Message section, type some text, then click on View in expression builder to open the pipeline expression builder. 2__at various locations of your choosing, insert some system variables by clicking on the variable names in the pane below t...