Forum Discussion

Roomie117's avatar
Roomie117
Helper I
11 months ago
Solved

Connecting ( Swagger UI) API to Power BI for Real-Time User Data by Username

When I select a username in the Web API, it pulls real-time data. Whatever name I select, it should automatically display the corresponding data in Power BI. The username is a required parameter in t...
Data Protection
General Comment
Interesting Links
Need Help
Tips and Tricks
  • v-echaithra's avatar
    v-echaithra
    11 months ago

    Hi Roomie117 ,

    Use Power Automate to Fetch API Data and Store in a Staging Location Blob / SharePoint / Excel / Dataflow

    Power Automate Flow:

    Trigger: Manual / scheduled / Power App / HTTP trigger.
    Action: Call the Web API with the selected username.
    Authenticate: Use the proper HTTP action with headers (bearer token / basic auth).
    Output: Store the result in SharePoint list / Excel Online file (OneDrive)
    Azure Blob Storage (CSV or JSON), Power BI Dataflow (best for large data)

    Power BI:

    Connect to the storage location (e.g., SharePoint, Blob, Dataflow).
    Refresh Power BI dataset on demand or schedule.

    Reference: HTTP actions reference - Power Automate | Microsoft Learn

    Thank you

Roomie117's avatar
Roomie117
Helper I
11 months ago

I would like to set up a workflow where selecting a value in the API automatically triggers a data refresh in Power BI through Power Automate. Essentially, when a specific value is selected in the API, the data in Power BI should refresh in real-time to reflect this change. Could you please guide me on how to configure Power Automate to achieve this integration

v-echaithra's avatar
v-echaithra
Community Support
10 months ago

Hi Roomie117 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.