Trying to Connect to an API

[Cesylyaa]

Hello everyone,
I am trying to connect to an API.

https://napimsv2-be-6efe8ae.herokuapp.com/api/docs/swagger/#/clients/clients_combined_production_ret...
(tweaked for security)

But I can't see the tables.

[v-saisrao-msft · Accepted solution]

Hi @Cesylyaa,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Thank you to the @lbendlin,@danextian, for your valuable insights. As mentioned, authentication is often the reason for seeing HTML code instead of actual data in the Navigator. By examining the HTML, you may find error messages like 401 Unauthorized or 403 Forbidden, which indicate authentication issues. 

Additionally, referring to the API documentation, as recommended, is an excellent way to ensure you are using the correct endpoint and following the proper authentication process. 

• Please ensure that you are using the correct API endpoint URL (e.g., /clients, /data) rather than any URLs intended for other purposes like API documentation. 
• To authenticate in Power BI, go to Home → Get Data → Web, enter the API URL, and select the appropriate authentication method (API key, OAuth2, or Bearer Token). Provide the necessary credentials or tokens to ensure secure access and retrieve the API data for analysis. 
• Before trying to connect in Power BI, test the API using tools such as Postman or curl. 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[v-saisrao-msft]

Hi @Cesylyaa,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Cesylyaa]

Hello,
I did speak to the backend developer who provided me the code.

He said there is no Username/password, so that implies no Authentication?
Is there still a workaround for this?

[v-saisrao-msft]

Hi @Cesylyaa,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Cesylyaa,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @Cesylyaa,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-saisrao-msft · Accepted solution]

Hi  @Cesylyaa,

Thank you for your patience! could you confirm if the API returns structured data (such as tables, JSON, or XML) instead of an HTML response?  

Here’s how to check:  

• Open the API URL in your browser and check its response. If you see JSON or structured data, the API is functioning correctly. If it shows an HTML page, the API may not be returning data in the expected format, possibly due to an incorrect endpoint or missing request parameters.  
• Use Postman to send a GET request to the API. If the response contains tables, JSON, or XML, the API returns structured data. If it returns HTML, the issue might be with the endpoint or required headers.  
• If the API returns only HTML, it could indicate an incorrect endpoint (such as a documentation URL instead of a data URL) or missing required headers or parameters for a proper response. 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @Cesylyaa,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Thank you to the @lbendlin,@danextian, for your valuable insights. As mentioned, authentication is often the reason for seeing HTML code instead of actual data in the Navigator. By examining the HTML, you may find error messages like 401 Unauthorized or 403 Forbidden, which indicate authentication issues. 

Additionally, referring to the API documentation, as recommended, is an excellent way to ensure you are using the correct endpoint and following the proper authentication process. 

• Please ensure that you are using the correct API endpoint URL (e.g., /clients, /data) rather than any URLs intended for other purposes like API documentation. 
• To authenticate in Power BI, go to Home → Get Data → Web, enter the API URL, and select the appropriate authentication method (API key, OAuth2, or Bearer Token). Provide the necessary credentials or tokens to ensure secure access and retrieve the API data for analysis. 
• Before trying to connect in Power BI, test the API using tools such as Postman or curl. 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[Cesylyaa]

Hello,
I did speak to the backend developer who provided me the code.

He said there is no Username/password, so that implies no Authentication?
Is there still a workaround for this?

[Cesylyaa]

Hi, this is a screnshot of the html.

I tried to connect again, but it just bypasses the authentication and does not ask me about authentication.

How can i get this authentication menu back?

[lbendlin]

go to Data Source Settings. Clear permissions. Reauthenticate.

[Cesylyaa]

Hello,
I did speak to the backend developer who provided me the code.

He said there is no Username/password, so that implies no Authentication?
Is there still a workaround for this?

[lbendlin]

In that case you would use "Anonymous"

[Cesylyaa]

I did.

Which takes me back to where we started from.
Here:

All i see is 

[danextian]

Hi @Cesylyaa 

There should be a documentaiton of some sort on how to get data using this API. This one is from Finnhub -https://finnhub.io/docs/api 

[lbendlin]

You need to authenticate to that API.  If you examine the HTML Code you will see the error message.

[Cesylyaa]

Hello,
i think that because i had previously attempted to authenticate without a password, when i input the link now, it just skips the authentication part.

This is a screenshot of a portion of the html code.