Hi all
I have an excel file with one tab stored in a box. I need to get the data from the URL of that box that contains the excel file.
When I do the get data from the Web option I get the following:
The steps I follow are then:
As seen, the table that contains the columns of the excel never appears.
How can I make the table appear using the link? The reason I need to use the link and not get it straight from the folder excel route is because I need other people to refresh the query.
Using the excel route would not work since it would be created with my user, therefore I would be the only one able to make updates.
I tried the same with one drive and didnt work either, here is a sample.
https://1drv.ms/x/s!ApgeWwGTKtFdhmBSr7ewHPMnY08Y?e=9Uz3gS
Thanks all.