82 Importing Data from REST APIs | Other Data Sources | Power BI

Hi,
Thanks for sharing. I have a question with using APIs in Power BI.
How to handle the access key or tokens that an API might need? Can this be done through Power BI easily?
Don't forget to tag me when you reply. Thanks once again @Speedilytech Team.

not much helpful until you show how to handle pagination in API

am trying to create a report puling the data from a REST API. The API however is secured using oAuth2, so in order to pull the data, an API call must first be made to /login/token API (using basic authentication) and the token returned needs to be used to authenticate the actual API call pulling the data. Is this possible with PowerBI


Can you please suggest on this ?

Thanks! Very useful. How PowerBI handle data updates? Can I tell PowerBI to refresh, rerun query every 30 minutes? Do I need to manually transform the JSON each time into a PowerBI table which would defeat the purpose of dynamic data loading... any help would be appreciated. Thanks!

Can the whole process be automated?

Thank you! This was very helpful 💙

You guy you are also here...Great!!!

Hello. I made my own REST API and I performed the same steps. Once the "Navigator" is open, I can see my data in "Web View", but not "Table View". Since it cannot be represented in the form of tables, it can't get loaded into PowerBI. Is there any way wherein this can be done? Please help. Thanks :)

very useful

Hello Sir, how can we fetch data from power bi as xml or json to my application using rest api

really i used this video thank you god

Hi,

I am getting data from an API that has two parameters like below in the URL:

Param1930=2021-01-01&Param1931=2030-12-31&format=JSON

These are the start and end dates of the report that I have manfully set up in the API URL. But, how do I make it dynamic so that everyday that I refresh the data in Power BI connect to the API and pull the latest data? My current M code is something like below:


let
Source = Json.Document(File.Contents("C:\Users\Ali\AppData\Local\Microsoft\Windows\INetCache\IE\EHD7MHFN\1120")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"txtProvider",
"txtIncidentNo",
"FltDate",
"LogTime")

Great work! Thank you so much for this video. With this example, I was able to do the same with multiple API connections.

Hi! I’m interested for learn more. Could I pay you for any classes? What it is your email for contact ? I really need improve that knowledge ! I will be waiting your answer

Hi my rest api needs a jwttoken for which i need to login to get jwttoken and then the token i valid for 2 hrs, after which we can get a new token maybe to get data. Could u please help for the same.

thanks mate!

Hi there, how do I get an api key from swagger. It is required in Power BI when trying to access the data on the API

This was very useful, Thanks!!

We have developed Angular and JAVA web application. We also integrated the Power BI Report via embedded token/URL, service principle, row level security etc. Able to access and display the Power Bi Report through iFrame in angular and java. Also successfully download the report in PDF and PPT etc. But we are looking for, how to implement the download report using bookmark or filter. Now we are able to download the report as whole not a bookmark or filter basis. How do we interact and pass the bookmark and filter information to download the report between Angular , JAVA and Power Bi Service Call. How we need to get the information of bookmark or filter from iFrame? Please let me know if anybody has any idea.

Rain, Rain Go Away...

Di you have a udemy course in power bi

Thanks! How to import data using GraphQL?