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?
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
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?
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.
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")
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.
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.
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.
![Building a Power BI Admin View [Part 1]: Connecting to Data from the REST API](http://i.ytimg.com/vi/cTqFNg_y9lw/mqdefault.jpg)
![Diggy Graves - Red Vineyard [Official Lyric Video]](http://i.ytimg.com/vi/8Ro085T0mnQ/mqdefault.jpg)
This was perfect. I have been looking around to find out how to essentially loop through API calls and this helped a bunch.
Really good presentation thanks. The sound was a bit difficult to hear at times, but really good information which will be useful. Thanks
Noted!
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?
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 ?
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?
can we provide dynamic access token to it? i mean i f we update data in api will it reflects in power bi desktop
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.
Starts at 9:06
Starts inputting code at 13:50
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")
Thank you for the video. It helped me a lot to understand APIs.
Glad it helped!
Token Identifier Expected, what kind of error is this?
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 ...
Hi John, What was the exact error message? I don't see it in your comment.
Super cool, thanks for sharing👍
Thanks for watching!
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
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.
Thank you. How do you connect to an API that requires username and password?
The Power Bi Web connector dialog allows you to enter these credentials.
need to work on audio, its too low
audio is not clear
Thanks for letting us know. We've improved our sound kit now.
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.
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.
Excellent
Legend