Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

Power BI API Call feasibility

Can below scenarios be possible in Power BI?   Scenario1: 1. User will input values in a form using a dropdown/filters/slicers, example Account ID and Product ID ( This form needs to be created in...
Need Help
  • jaineshp's avatar
    jaineshp
    1 year ago

    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

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago

Hi jaineshp ,  how to achieve below highlighted in Power BI?

 

 

jaineshp's avatar
jaineshp
Memorable Member
1 year ago

Hey powerbiexpert22,

Here's how to capture current slicer values in Power BI for Power Automate:

Quick Solution Steps

Power BI Side:

  • Create report parameters matching your slicer fields (Account ID, Product ID)
  • Link slicers to these parameters in slicer properties
  • Publish report to Power BI Service

Power Automate Side:

  • Create flow with "Power BI" trigger or manual trigger
  • Add "Get dataset parameters" action from Power BI connector
  • Use retrieved parameter values in your HTTP/API calls

User Experience:

  • Add Power Automate visual to your report page
  • Users select slicers → click flow button → values get processed
  • Flow runs with current slicer selections automatically

Key Point: The "Get dataset parameters" action is what pulls your current slicer values. This works because parameters update when slicers change.

 

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


Best Regards,
Jainesh Poojara | Power BI Developer