Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Null when extracting data from a web

Good day!   It is my first time trying power query and I can't seem to extract data inside the box, where our team enters data: Showing Null when I change the type to number - was initially ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi Anonymous ,

    It may depend on the structure of your web.

    If the structure is a open-box web which is provided for user to enter any data, perhaps the data would not be loaded in Power Query.

     

    When you use the web connector to connect to the web source, you can check whether there are valid tables in the Navigation page before you import them into Power Query:

     

     

     

    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.

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

Hi Anonymous ,

It may depend on the structure of your web.

If the structure is a open-box web which is provided for user to enter any data, perhaps the data would not be loaded in Power Query.

 

When you use the web connector to connect to the web source, you can check whether there are valid tables in the Navigation page before you import them into Power Query:

 

 

 

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.