Question
You create a canvas app that uses data from a Microsoft SQL Server database.
You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will filter the data by using the app.
You need to filter data in the dataflow and in the canvas app.
Which tools should you use? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Filter data in the dataflow: Power Query. Dataflows are built in Power Query Online, so filter steps defined there remove rows before the data is loaded into Microsoft Dataverse. Filter data in the canvas app: Power Fx. Canvas apps use Power Fx formulas such as Filter, Search and LookUp (for example in a gallery's Items property) to filter records, and these are delegated to Dataverse where possible. T-SQL is not written inside a canvas app, and Kusto (KQL) queries Azure Data Explorer and Log Analytics data, not dataflows or canvas apps.
