Can you provide a sample of the URL you're using as well as some more information about what is not working? Is it just not showing anything? Is it producing an error?
when url similar to this is added to the webpage object of Tableau, it shows blank excel tab, something like this:
opening the same link in browser displays the data correctly.