Gathering data from APIs in Power BI

Gathering data from APIs is an effective time saving method to get up-to-date information. We’ll explore how to achieve this by pulling information from the Nasdaq stock market so you can track stocks in an automated way. Even if you don’t use stock market information, there is a plethora of data you can access via APIs and it’s an incredibly useful technique.

[@wonkibonki948]

This was perfect. I have been looking around to find out how to essentially loop through API calls and this helped a bunch.

[@PaulEBrownbill]

Really good presentation thanks. The sound was a bit difficult to hear at times, but really good information which will be useful. Thanks

[@LondonBusinessAnalyticsGroup]

Noted!

[@eagillum]

Starts at 9:06 Starts inputting code at 13:50

[@innamizulina6791]

Super cool, thanks for sharing👍

[@LondonBusinessAnalyticsGroup]

Thanks for watching!

[@nirmaljoe1761]

I am getting OLE DB or ODBC error: [Expression.Error] The field 'Monthly Time Series' of the record wasn't found.. If I am trying to update one or more stock records. How to fix this?

[@jbgonzalez13]

Thank you for the video. It helped me a lot to understand APIs.

[@LondonBusinessAnalyticsGroup]

Glad it helped!

[@harshtrivedi700]

need to work on audio, its too low

[@ambarishsharma6432]

Excellent

[@pritichaudhari7596]

Hello, Would you please make a video on, how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework. Thank you.

[@sridharreddy3493]

hi , 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 ?

[@prasanthalpha]

Please speak up! The audio is very difficult to hear. You are barely audible even after keeping the volume at 100% and using noise cancellation headsets.

[@rich83rs]

technology has come such a long way to date in 2021, for which we are grateful ...however... having content creators use a suitable microphone/sound source for their presentations still alludes us.

[@shubhampatel3582]

can we provide dynamic access token to it? i mean i f we update data in api will it reflects in power bi desktop

[@leopark7395]

Thanks for sharing. Do you have any advice for pulling market data for a larger list of tickers (~50-100) with AlphaVantage's API call limitation in mind?

[@tanaynagarsheth4762]

Token Identifier Expected, what kind of error is this?

[@johnhartley2438]

Gr8 session on APIs yesterday. I've tried to run through material, but get this syntax error around the API key. Obviously, I did enter my own but ...

[@LondonBusinessAnalyticsGroup]

Hi John, What was the exact error message? I don't see it in your comment.

[@ahv5457]

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

[@akhilkp5378]

audio is not clear

[@LondonBusinessAnalyticsGroup]

Thanks for letting us know. We've improved our sound kit now.

[@1yyymmmddd]

Thank you. How do you connect to an API that requires username and password?

[@LondonBusinessAnalyticsGroup]

The Power Bi Web connector dialog allows you to enter these credentials.

[@DubShah]

Legend

[@nazishali137]

Can I do same for SOAP API as the source i have is providing me with Soap Api and I need that data in PBI

[@chrisbarber639]

SOAP APIs dont work in the same way as rest APIs and there is currently nothing in the microsoft to be release list to enable a connector for this. 1 option could be to look at dreamfactory who have a SOAP to rest API conversion; this is not something I have personally used. You could also use python within Power BI to allow you to connect to the soap API.