Power Query produces white page

[stoutbn]

I want to get the contents of an input table for a data repository our company stores online. I copied the url of the input table and tried the "From Web" option within power query.

When I try to load it sends me to the query editor page showing a white piece of paper with the url beneath it and file size in bytes. (cannot attach picture)


When I right click the file and select CSV or Excel file, I either get several lines of code that I don't understand or a failed excel connection.

Does anyone know the solution to this or why it does not work? Thanks!

 

[Matt Allington]

What do you mean it is an input table? Is it empty boxes on a page that you must enter data in to? Power query can only extract data from web if the data is in tabular format.

 

[stoutbn]

This input table has a web url which is why I assumed it was possible to use with power query. But it also has .application in the url which may mean that it is a custom app and why I am having a problem. What determines whether the data is in tabular format? Sorry I am fairly new to this.

 

[Matt Allington]

What determines whether the data is in tabular format?

Generally it is HTML Table tags and I am guessing DIV tags as well. The easiest way to test is to point Power Query to the URL and see what it finds. If it doesn't find the data you want, then it can't read it. I guess this brings you back to where you started - it just doesn't work on your data. Sorry, I don't think there is any secret sauce that you are missing - if you are copying the URL from the web page where you can see the data you want, and when you paste it into Power Query you don't see the table, then I think you are out of luck.

 

[stoutbn]

I see. Well thank you for educating! I appreciate the help anyways!