Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query running slow through google search

Hi there,    I am currently working on creating a new data basis and for that I need some informations for companies (APE code in French). I only can find these informations easily on Google when I...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Does it have to be in Excel?  Power BI has a new web table inference that works reasonably well with google search results.

     

    How are you planning to extract the actual APE/NAZ code?  It can appear in any of the results?

     

     

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi Anonymous ,

You can try to split the entire data table into multiple small data tables and then call the custom function. Each URL will send a query. Sending queries with too many URLs in a table at the same time may cause slowness or long-term failure to respond.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-yingjl ! 

     

    Thanks for you message. Yes I did try it before and did not work on Excel (more that 50 URL's were too much). But the solution from lbendlin on Power BI worked for me (I can do like 1000 links in 15 minutes when I was doing 200 links in a day with Excel...). 

     

    Thank you a lot :!

     

    Best,