Forum Discussion

Roomie117's avatar
Roomie117
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity Support
11 months ago

Hi Roomie117 ,

I hope the information provided is helpful. I wanted to check whether you were able to resolve the issue with the provided solutions. Please let us know if you need any further assistance.

Thank you.