cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sowmiya Member
Member

Connecting Power BI with API

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.

1 ACCEPTED SOLUTION

Accepted Solutions
zoloturu
Advisor

Re: Connecting Power BI with API

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!

View solution in original post

5 REPLIES 5
zoloturu
Advisor

Re: Connecting Power BI with API

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 Member
Member

Re: Connecting Power BI with API

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
Advisor

Re: Connecting Power BI with API

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.JPGapi 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.JPGapi 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 Member
Member

Re: Connecting Power BI with API

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?Error.png

 

zoloturu
Advisor

Re: Connecting Power BI with API

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!

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 341 members 3,626 guests
Please welcome our newest community members: