Getting Started with Power Query APIs - It's surprisingly easy!

How to get data from web which has id and password?

How do you handle bearer tokens being required by the API? I have an API that requires a POST call that returns a temporary code used in other GET calls so there is a sequence to it...

thanks im trying it, and it seems to only have the options when the connection is available, otherwise you can also find the authentication settings still I noticed

its also asking how much of the packet to apply the password to on one prompt


in the "data"banner next to from web
data source settings drop down
goto data source settings
then global settings
and then edit permissions button
to see those hidden features

This was so clearly explained, so easy to understand. It really helped me at work, thank you very much for creating this video.

Super

How to get data from amazon website?

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

Thanks for this, I was struggling to find the option to remove the json element name as column prefix b/c PBI was automatically doing the expansion for me, and I saw from this that there is a checkbox for that on the 2nd step.

👍👍👍 very useful

This was helpful for a basic unprotected source request. Do you have any videos on how to access an API that requires a key and credentials (not Windows but a different company's credentials that they provide)?

Very helpful.Thank you for sharing your knowledge

Thanks, can we do the same for the software like dhis2 ver 2.37

Very impressive. Thank you for simplifying API connections without all the code and questions about which programming languages etc

Very informative video. Thank you.

Hi Mynda.. could you please guide in how to connect jira with power using rest api... that would be of great help

Hi Folks, Need some help.
How can I use "or" command in API data extraction. I can easily use "&" to filter from multiple columns (for eg: select rows with Value "Canada" in Country_column, & value "Hockey" in Sports_column: api/reporting/request?Country=Canada&Sport=Hockey). But what syntax will I use for selecting two values from the same column. For eg: if I want all data where value is USA Canada in Country Column?? (I tried " ; " , "or" and parenthesis, nothing worked!!)

I have to do this as my API fails with the large volume of data, so i can fetch in small sizes.

Can pls tell how to create trans query api structure

Well done

thanks

Thanks

thank you for your useful video!

i am wondering, does anyone here perhaps know how to deal with APIs, which require their header to be sha256 encrypted, using user data as keys?

Thank you for the video… my office internal website data am trying to obtain but unable to get the out put. We use authentication code once we login to web browsers to access complete day. Later the site asks for only user info and we don’t need to provide any password…. Just continue to the site

Thanks in a million. Great content. Awesome. Grade: A++💥

thank you! so much!

Hi Mynda. Super interesting topic. Lots to study and learn. Thanks for sharing :)) Thumbs up!!

thank you

Hello, how would this work if i don't have a API URL, but just a client ID and secret?

I am trying to understand why use python when you can use excel...

Great tutorial,❤️
Can you help with posting a post request rest apis or with query params with authentication mostly basic LDAP authentication ?. Thanks in advance 👍

Hi
I'm trying to retrieve data from Companies House into excel but the API key provided doesn't isn't a URI, it's a string that looks like like this: d4e7d319-2034-47af-b8a0-cdc9ec2e410c. I can't get excel to understand this.
Any ideas?
Many thanks
- Cuala

Hi thanks for your help
How can reach to site witch need login ??
I tried , but after past the link to get data its fail to access data

how to make a post request with json payload is there any example ?

Excellent tutorial. Is it possible to change the style of the table exported by PQ? I am actually annoyed with the green stripes

Very Useful!! Pls. provide me help on the below

Query related to editing Multiple XML Files through excel and saving the the updated data in the Multiple XML files

1.First I imported multiple xml files in excel with mapping the certain fields which I need to edit.

2. Then I edit the data on the mapped fields.
3. I am having problem in updating the edited data into individual multiple xml files
Can you help me on this????

Interesting and unknown topic for me. Thank you very much for providing information about this issue Mynda.

Ppl make sure to watch all the ads to the fullest because this channel deserves it!

I have question plz

Can API querry get the data from each publication at the web source, just by refresh and without consulting the web?

Other side your channel it s unblievable !!!!

Great!. I have uploaded my sample. Thank you for your help. under "To summarizes data of Sku select one sku, will display unit weight, change qty of the item say 1,2,3or4 ..unit this will give the total weight of the item(s). | General Excel Questions & Answers | Excel Forum"

Hello ma'am my power query not show PDF import options

I have to say that this is the answer to a question I didn't know how to ask. It's info I needed but didn't know it's technical name. Now I need to reverse the process and display the garnered data on a web page. Is this part of your remit or can anyone reccomend some further resources?

Will this work with Excel 10

Thanks for sharing this information,
I have a question, I have a api link, there are all customer details, I wanted to get the selected customer from entire data, selected customer are not fix so I will add those selected customer Id in Excel column, and I need the details for these customers only, how can I do this

Большое спасибо!

Informative steps, thanks!

Really informative and detailed videos. I recommend it to all my colleagues.
Do you know if someone does such videos about SharePoint. If you can recommend any please. Will be greatly appreciated