Get data from web not showing table and data

[amir29918]

Using the following URL:
https://fibalivestats.dcd.shared.geniussports.com/u/ISL/2212206/bs.html

there are few data but now showing (show blank or null) in power bi & excel

[v-xinruzhu-msft · Accepted solution]

Hi @amir29918 

After testing, when input the URL, it can give the related value in the table

Maybe you don't open the web table inference in the option. Please check it , open '  File > Options and settings > Options > Global > Power Query Editor-> Enable web table inference option , open it, then save the change and reopen the deskop again, and input the URL, then the system will give you the suggested table.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.