This was great thank you. I was wondering if you could do a video explaining how to run multiple curl api's through Excel where multiple parameters are required to fed to each request. Eg. same url each time but a different Authorization token. Eg. Bearer xxxxxxx
A nice explanation and in a lucid manner. If I want to fetch a data having say two or more functions say having year and studio wise how can we do? Also If we make a dropdown can it be fetched?
create a reference in xls to the source table years (all years you are interested) and make it as a selection list where you can select just the year you want. Put this selection list cell as a new table and use the function like visible in this video on this table. If you select one year, the function just apply to the value of the selecton and gives you the data from that year.
Great video. If I specify a year for which there is not a web page in boxofficemojo I get an error message and the program stops. Is there a way to get Power Query to ignore that specified year and move on to the next one. Thanks
Hello Sumit...excellent videos...i have a question..suppose I have 2 tables. Table 1 is static and Table 2 fetches data daily. Can I somehow combine the two tables so that whenever I refresh the table 2, new data from Table 2 is automatically added to the Table 1 without replacing any previous data. Thank you.
The below query is giving an error An error occurred in the ‘S_infoFx’ query. DataFormat.Error: We found extra characters at the end of JSON input. Details: Value= Position=0 Please advise.
This helped a lot.
I used this to extract data from a folder, where such folder path can be given user in a cell/table.
Exceptional. Left speechless!
Just wanted to say that thanks to you I've been using power query and it helped me get a job.
Congratulations... So happy to hear this 👏
which job did you get please care to share
These videos are exceptionally helpful in a short amount of time. Thank you for all the work you're putting into do this.
This is a real game-changer! I feel oblidged to deeply thank you for your effort.
Very clear and nicely explained. Thank you for these quality content
This is fantastic stuff, with an even better presentation. Well done!
Very Good , Very Helpful.
Excellent tutorial! Thank you 😊
Thanks Vivienne... Glad you found the video helpful 🙂
explained in a very simple manner. Amazing work
I just can’t thank you enough🙏
Glad you'l found the video helpful 🙂
Best info thanx sir for this valueable vedio🙏🙏🙏🙏🙏🙏🙏🙏
mashallah sir dil kush ho gia
Excellent tutorial, thanks for sharing👍👍
hi sumit bhansal, thank you for your course
This is so amazing. I love the way you teach. Thanks for sharing
Web scraping in Excel very impressive.
Great video. Thanks for sharing. 🙌🙌🙌
Awesome demo
Really interesting topic
Thanks a lot.
Awesome. I didn’t knew about it. Let me try for my work too
Amazing...very nice...excellent voice
This is really amazing. Thanks for sharing this
Thanks for commenting Shirish... Glad you found the video useful!
welcome :). have you written a book for PQ?
Great This is so amazing. Can we use invoke custom column using two column in one table.
This was great thank you. I was wondering if you could do a video explaining how to run multiple curl api's through Excel where multiple parameters are required to fed to each request. Eg. same url each time but a different Authorization token. Eg. Bearer xxxxxxx
Amazing
Very Nice
A nice explanation and in a lucid manner. If I want to fetch a data having say two or more functions say having year and studio wise how can we do? Also If we make a dropdown can it be fetched?
create a reference in xls to the source table years (all years you are interested) and make it as a selection list where you can select just the year you want. Put this selection list cell as a new table and use the function like visible in this video on this table. If you select one year, the function just apply to the value of the selecton and gives you the data from that year.
Great video. If I specify a year for which there is not a web page in boxofficemojo I get an error message and the program stops. Is there a way to get Power Query to ignore that specified year and move on to the next one. Thanks
Hello Sumit...excellent videos...i have a question..suppose I have 2 tables. Table 1 is static and Table 2 fetches data daily. Can I somehow combine the two tables so that whenever I refresh the table 2, new data from Table 2 is automatically added to the Table 1 without replacing any previous data. Thank you.
wonderful
The below query is giving an error
An error occurred in the ‘S_infoFx’ query. DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value=
Position=0
Please advise.
How to transform data from GDMS to power query
Same content - Same material Copied from Computergaga