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!
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!