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

[Roomie117]

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 the Web API; without it, I cannot retrieve any data. Currently, I can pull information for one user by parameterizing the query in Power BI. Additionally, the API requires authentication. how to handle this in powerBi , since we cannot get real time data into powerbi what are the alternate options and  I tried with power automate getting 

BadRequest. Http request failed as there is an error: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

 443

[v-echaithra]

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.

[v-echaithra]

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.

[collinq]

HI @Roomie117 ,

Since you can't use real-time with parameters on an API this sounds like this might be a great case for Power Automate.  You could have Power Automate store your parameters and handle the authentication and then have Power BI connect to that and run the refresh.

443 though might be an error about not reaching the endpoint.  (It might be just timing out based on the authentication.)  You may need to increase timeout settings and/or confirm that it is reaching the endpoint (but that is still the secondary issue at the moment I believe).

[Roomie117]

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]

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.

[v-echaithra · Accepted solution]

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