Pulling live data - filtering problem

[Chyrinnao]

Hello! 🌸

I am following along with this video (https://www.youtube.com/watch?v=3Rz71VNiFDI) to try and pull live market price data for different Lorcana cards. I've used Power Pivot before, but I'm still pretty new (only a few months old).

I'm at the step where he is filtering for specific names from the website code (2:20~). Here is what I have:

I thought I would start with the name and then try and filter for the market price, however, it returns nothing.

Can someone tell me how to filter correctly?

Thank you SO SO much to anyone who can help!!

[Anonymous]

Hi @Chyrinnao 

I checked the code received, it appears that not all html codes are there in Power Query Editor. Only some <script> codes are received. Nearly all data in <div> isn't there. The data is not complete so you cannot filter to find it. 

Best Regards,
Jing

[Chyrinnao]

Yeah, I think you're right. How can I download and connect all of the data?

[amustafa]

From your screenshot you are missing the xtra underscore between details and name "product-details__name". Make sure you copy the exact same string to filer the values. Hope this helps.

If I answered your question, please mark this thread as accepted and Thums Up!
Follow me on LinkedIn:
https://www.linkedin.com/in/mustafa-ali-70133451/

[Chyrinnao]

You make an excellent and valid point. I tried to filter again with one _, two __, and three ___ and it didin't give any results. I think there was something from with the data import.