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

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

Hi Roomie117 ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.