Power BI API Call feasibility

powerbiexpert22 

Go with Scenario 2 - Power Automate Route

Why this works better:

• Power BI doesn't have true submit buttons, but Power Automate can bridge this gap
• Microsoft's native integration means fewer compatibility issues
• More reliable than trying to force Python/Java calls from Power BI

Implementation Steps:

Step 1: Power BI Setup

• Create your report with slicers for Account ID and Product ID
• Set up report parameters that capture slicer selections
• Configure the report to work with Power Automate triggers

Step 2: Power Automate Flow

• Create flow triggered by Power BI data changes or manual trigger
• Use "Get data from Power BI" action to fetch current filter values
• Add your database API call using HTTP connector
• Handle response and update target systems

Step 3: User Experience

• Users interact with normal Power BI slicers (feels like a form)
• Add a bookmark or button that triggers the flow
• Flow runs in background and processes the selected values

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer