Connecting Power BI with API

[Sowmiya]

Hi,

Am new to Power BI, Here in my case I am having my own API key, I have searched lots of methods but it gets failure. Please guide/instruct me how to connect Power BI with API, step by step process from beginning.

[jshirley]

Where would you put in the data from the link that you are suggesting @zoloturu?

[zoloturu]

Hi @Sowmiya,

Please post a link to the documentation of that API method here (type of http request, link, headers, body etc.)

Regards,
Ruslan

[Sowmiya]

Hi Ruslan,

I am new to API Connection with Power BI. Here is the Documentation Link - http://www.datamedia.org//. I have an API Key but I don't know how to generate Session Key and how to request Data.

Regards,

Sowmiya

[zoloturu]

Hi @Sowmiya,

Please try below approach:

1. Go to Get Data -> From Web and enter https://server/GetSessionToken (replace server with actual server name). Press OK.

api 1

2.  You will see a window with authorization types, choose Web API

3.  Enter your API Key into the text field and select full HTTP request from a dropdown list like below:

api 2

4. Press Connect.

P.S. If you will have errors you can post them here as well.

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

[Sowmiya]

Hi Ruslan,

I tried as per your guidance. But i am getting an error. Hereby I am attaching the screenshot of the error message. Can you help me in solving the error?

[zoloturu · Accepted solution]

Hi @Sowmiya,

In this case please try an approach from this link.

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!