Session

Playing with Translytical Task Flows

Microsoft's Translytical Task Flows in Power BI are a game-changer for building dynamic, interactive solutions that transcend traditional reporting. In this session, we'll learn about Translytical Task Flows, seeing how they can be use to make a fully functional Sudoku game directly within Power BI. Leveraging the full power of Microsoft Fabric for game state management.

Attendees will gain hands-on insights into:
• Implementing Translytical Task Flows to trigger Python UDFs from Power BI buttons.
• Designing and creating a robust Fabric SQL database schema to manage complex application state (e.g., game progress, pencil marks).
• Using SQL stored procedures as APIs for data manipulation (e.g., initializing games, setting cell values, toggling pencil marks).
• Developing Python UDFs to act as the bridge between Power BI and backend SQL procedures, including error handling and response formatting.
• Advanced Power BI report design techniques for highly interactive experiences, including using button slicers for grid interaction and SVG measures for dynamic cell rendering.
• Implementing Row Level Security (RLS) to provide personalized experiences for multiple users.

This session will move beyond theoretical concepts, providing practical code examples and architectural blueprints for how you can apply these cutting-edge Fabric capabilities to build sophisticated, interactive solutions, whether for playful applications like a Sudoku game or complex enterprise-level data entry and workflow management systems.

Jake Duddy

Zure, Data Engineer

Birmingham, United Kingdom

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top