I'm using the "Get Data" to extract tables from pdf documents.
This feature works great except for when my file is stored on an MS Teams channel.
In this case I use the following steps
1. Copy the file location in Teams
2. Get Data>From File > From PDF
3. Paste location.
4. Click OK
Upon clicking "OK" my mouse pointer clicks twice, but nothing really happens.
The same scenario happens even when I want to get data from another XLS file stored on MS Teams.
The link you get from the Copy link function in teams won't generally work as a file path. You should open the file in Sharepoint and get the link from there.
Thank you for the suggestion.
I open the folder in Sharepoint and then clicked "Copy Link" That resulted in the same problem.
Then I tried to click Details>Properties>Path>Copy Direct Link. When using this option the Get Data works as expected.
