Power BI Beyond Read-Only: Writebacks and Automation with Fabric User Data Functions
Proposed session for SQLBits 2026TL; DR
Learn how Fabric User Data Functions turn Power BI from read-only to actionable. See how to run Python logic in Fabric, enable secure writeback, and build translytical flows with live demos, bridging analysis and action directly from reports.
Session Details
For years, Power BI has been a "read-only" window into your data. When users need to take action, updating a record, triggering a workflow, or running a custom algorithm, they are forced to leave the report. But what if your dashboard could act as the command center for your data?
Enter Fabric User Data Functions. This session introduces a paradigm shift for Power BI professionals: the ability to host and run custom Python logic directly within the Fabric ecosystem. We will tackle the long-standing challenge of implementing "writeback" and custom automation without the overhead of managing external Azure Functions or Power Automate. You will learn how to encapsulate business logic into reusable REST endpoints that bridge the gap between analysis and action.
Through live, end-to-end demos, we will build a "Translytical" flow from scratch, moving from writing the Python code in Fabric to triggering real-time data updates directly from a Power BI report interface.
By attending this session, you will learn how to:
✅ Master the Fundamentals: Understand exactly what User Data Functions are and where they fit in your Power BI solutions.
✅ Build & Deploy: Set up your first User Data Function.
✅ Enable Secure Writeback: Implement secure, reliable data writeback patterns that allow users to update sources directly from a report.
✅ Architect Translytical Flows: Design workflows that combine analytical insights with transactional execution in a single step.
✅ Extend Your Reach: Use the power of Python to bring automation and external connectivity to your BI solutions.
Enter Fabric User Data Functions. This session introduces a paradigm shift for Power BI professionals: the ability to host and run custom Python logic directly within the Fabric ecosystem. We will tackle the long-standing challenge of implementing "writeback" and custom automation without the overhead of managing external Azure Functions or Power Automate. You will learn how to encapsulate business logic into reusable REST endpoints that bridge the gap between analysis and action.
Through live, end-to-end demos, we will build a "Translytical" flow from scratch, moving from writing the Python code in Fabric to triggering real-time data updates directly from a Power BI report interface.
By attending this session, you will learn how to:
✅ Master the Fundamentals: Understand exactly what User Data Functions are and where they fit in your Power BI solutions.
✅ Build & Deploy: Set up your first User Data Function.
✅ Enable Secure Writeback: Implement secure, reliable data writeback patterns that allow users to update sources directly from a report.
✅ Architect Translytical Flows: Design workflows that combine analytical insights with transactional execution in a single step.
✅ Extend Your Reach: Use the power of Python to bring automation and external connectivity to your BI solutions.
3 things you'll get out of this session
Turn Power BI reports into action hubs with secure writeback and automation
Build and call Fabric User Data Functions using Python and REST from Power BI
Design translytical flows that combine analytics and real-time execution
Speakers
Dhyan Rathore's other proposed sessions for 2026
Power BI on a diet: 5 TIPS to slim down your semantic models - 2026
Power BI’s Hottest Upgrade - Developer Mode with TMDL - 2026