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

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

Love you, for saving my job😂❤

Thanks Mynda for this video! You opened a new way for me to connect and work on interesting data from web! And yes, it was in that unique Mynda style which we have come to love! 😊👍

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

Thank you Mynda. As always, very interesting information. Your videos provoke new thoughts and ideas.

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

Excellent, thank you! I was using Python to hit an API and storing the parsed json in a SQL Server table but this might save me some steps!

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

Clearly and pleasantly presented as always. Thanks :)

Very helpful.Thank you for sharing your knowledge

Loved this tutorial Munda, thank you. I will experiment with this...

thanks

Very informative video. Thank you.

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

Hi Mynda!Great Tutorial,Really Helpful Info...Thank You :)

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"

Thanks

thank you

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

Informative steps, thanks!

Very interesting Mynda!

Excellent , thank you.

I really appreciate the video, Mynda, because at least I suspect that using Power Query to download data from KZfaq Analytics API is possible. Unfortunately, using this video's instructions I wasn't able to actually do it. It seems there are some steps I'm just not understanding. I'm not an engineer or analyst, and although I'm smart, this stuff leaves me feeling stupid. I would gladly pay for coaching or a video specifically on how to do this with the KZfaq Analytics API. I've spent over an hour looking for that online today, and can't find one that helps me get it done.

thank you! so much!

Hi Mynda, this is a video I've needed to watch. APIs have been a bit of a "Voodoo" topic for me, but it is something I need to learn, thanks for the video. Is this topic on your newsletter?

Well done!

Well done

Hi, great video! I was wondering if you know how to incrementally load the Data from an API. I have a currency feed and I would like it to keep the previous date's values as well as input the current date's values.

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

This is cool. Not sure when I’d use it really but cool! Have you discussed how to create cubes? I’m pretty new using excel to pull data with analysis services but I noticed the existing cubes I’m pulling from don’t always contain the fields I need. I’d love to learn how to create cubes. Probably way over my head. Also, is there a way to specify “current” date periods when importing data from analysis services to excel in order to avoid continuing updates to date parameter filters? Like instead of specifying “year 2020” I’d like “current year”. Sorry this is off topic but you seem to know everything! 🤗

👍👍👍 very useful

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

Thank you for the tutorials, can you explain the distribution formulas also?

Starts at 2:58

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.

Great Job Many Thanks My question is: how I can get an API for any website?

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

Can pls tell how to create trans query api structure

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 👍

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?

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?

Thanks! But I have problems when I try to follow your lesson with Excel for Mac. Could you please add some info for people that have this OS? Thanks a lot!

How to get data from amazon website?

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, can we do the same for the software like dhis2 ver 2.37

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

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

Super

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

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

Hi I have a question I want to login with a username and password and a client ID and secret via API? Is this also possible?

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

Is there a reason why you use incognito windows? Thanks

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

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

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

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

Use Power Query to call API that requires Auth & share excel file to non-technical colleagues How to do this

3:20 Hi, I had a query set up nicely then excel asked again how do i want to connect and by mistake i did not select anonymously this time and selected some other option, now excel keeps throwing errors and i can't find out how to change this setting to anonymous again. please help if you know how to solve this

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

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

Will this work with Excel 10

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.

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

I like the way you explain. You great knowledge about. I need you help. 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). Which is rounded to number. I have origin zip code to Destination zip to get zone. Once total weight (max 150 lbs/68 kgs)is figured out and zone then it needs to go and check row for corresponding and corresponding column different service type (Priority/Standard/2Day/Ground).and display on first page. I have one example of heading and sku with I need to pull from other tabs and display in first page. SKU:12545470 / Description:E Product item / Unit Shipping Weight (lbs):1.6 / how many max150 lbs/68 kgs:1 / total weight max150 lbs/68 kgs:1.6 / Total Weight Round off (=CEILING(J#,1)):2 Origin Zip :98101 /Destination Zip :12508 / Destination State:NY / Zone:8 . Priority Tab Cost:37.51 / Standard Tab Cost:34.17 / 2Day Cost:17.14 / Ground Cost:8.70 Please advise you are able to teach me how I can do this. I will really appreciate your help. My email address is rakavon@yahoo.ca or rakavon@gmail.com. I can email you the file.

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 !!!!