Yes we want more power query and M language videos. Thanks Sumit for all the videos ur doing.😊

@trumpexcel

Ай бұрын

Ok.. Noted. Will add more PQ and M code videos in the future videos

Great video and explanations, thank you Sumit 👍👍

Really useful video on using Power Query with multiple pages! It's great to see how to streamline data extraction into Excel. I also use Plerdy for free on my site to monitor user interactions, which helps enhance our data-driven decisions without needing complex setups. 👍 Excited to apply these tricks to our analytics tasks!

Thank you Sumit. Very interesting! Please do add more of such content using power query. For example how to login and extract account balances from multiple accounts from brokerages' web pages.

This is brilliant, it's given me an idea how to speed up a task I do daily manually. Thank you so much!

@trumpexcel

Ай бұрын

Thank you... Glad you found the video helpful 🙂

good stuff Sumit! Thanks for doing this!

Thank you for this!!

Yes , would love if you can release videos on advance power query and M language❤

Great Video thank very much

Thank you so much 🙏🏼

Awesome, keep doing that. good job.

Great stuff, thank you!

@trumpexcel

Ай бұрын

Thanks Ebin 🙂

wow ,excellent

Thank you, so clear..how if the table in the page is using a dropdown to control the data view (default is 10 data), i want to transport "all" view

Hi, this is great tutorials. it would be better if you also add how to get the data until "end of page" e.g. page 103 (or whatever it is)

Good

Thank you very much,...🤩 Very much Interested on M CODE and PQ........🤩 One question - if I want to load these table page by page to excel instead of combining all together in one page, is there anyway we can achive that.

@trumpexcel

2 ай бұрын

You can do that by creating separate queries, as one query can only load to one table as far as I know. So you will need to have 5 different queries if you want to get the data from 5 different pages

Thanks, dear Sumit it was a very nice and informative video. But there is something that I did not see anybody talk about in the comments. No matter how many pages you are scraping, all the dates are getting collected wrong. I mean scraped dates are not identical with the relevant dates on the website itself. This issue can be seen in your video too Please advise on this issue. Thanks a gain

Thanks Sumit, really useful. I tried this myself, for some reason it doesn't show the tables 12 and upwards, it only shows the tables up to 10 which doesn't have the comments. I use exactly the same URL as you were using.

@trumpexcel

Ай бұрын

Can you give me the URL you used and I will try on my system. I tried for one of the airports (Heathrow) and it was able to fetch 12 pages (120 reviews)

@user-nd6lj4my4g

Ай бұрын

I can see the comments on the web page as per your tutorial. Maybe it's to do with the excel version I use, mine is office 2019.

❤

Love your work! Why do you delete the latest step just to update the Change Type step? You can do that without that latest step being deleted. I know you already know this. Just wondering why are you using that method. 🤔

@trumpexcel

2 ай бұрын

Coz I want the change type step to be before I invoke the function. This way, when the function is used, it uses the number value input as text. If I invoke the function and then have the change type step, I would still get the error (coz of wrong data type)

Hi Sumit, Not getting table no.12. Only showing till table no.10. there is no option of suggested table in my wokring sheet

Hi, I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets. How can I do that? Thanks

@trumpexcel

2 ай бұрын

You can do that using hyperlinks. Have a look at this - trumpexcel.com/hyperlinks/#Create-a-Hyperlink-to-a-Worksheet-in-the-Same-Workbook

@benosborne413

2 ай бұрын

Thanks

@benosborne413

2 ай бұрын

Thanks

but how to get table 12 that is used while scrapping page 1

i am unable to extract data from website to excel. I am getting the error access to the website is forbidden

Hey Sumit. I am getting only 10 pages, page 12 is not availbale in powerquery as you showed in the video...!!!

Why i dont see table 12

Power query if I have some rows and column have space how?

@trumpexcel

Ай бұрын

Not sure I understand the issue... can you please explain a little more

@wongpeggy4363

Ай бұрын

@trumpexcel my aging report. There is some space how to combine

Hi

Sumit, I have problem here