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

IMPORTANT FILES
DATA.ZIP

[fseruya]

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

[nicafaustinoVC]

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!

[sureshus]

really i used this video thank you god

[kedar]

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 :)

[ahv]

Hi,

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



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" = to Table", "Column1", {"txtProvider",
"txtIncidentNo",
"FltDate",
"LogTime")

[bvnhome]

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

[cfmqznm]

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

[sridharreddy]

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 ?

[rajnishsasmal]

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.

[dhruvinshah]

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.

[thekhanshaakir]

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.

[mohammadsaleh]

Di you have a udemy course in power bi

[ambarsingh]

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

[luiscarlosmaldonadocely]

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