(posting as issue as suggested by desktop forum) Hello, I have a dataset that imports from multiple excel files within a SharePoint Folder (~10 tables from ~20 files). I am using the transfo...
Let me share the way to solved the issue that I already found
When I checked the M code for Excel´s Sharepoint that was work I found that the url was:
--> https://xxxxxxx.sharepoint.com/sites/.../xFile%20Name_xlsm/_api/contextinfo
But when I checked the source that was giving troubles, the url was:
--> https://xxxxxxx.sharepoint.com/sites/.../xFile Name_xlsm/_api/contextinfo
Notice that the space character " " is replaced with "%20"
I made a new conecction wiht the source that was giving trouble and (I don´t know why) the new URL was:
--> https://xxxxxxx.sharepoint.com/sites/.../xFile Name_xlsm/_api/contextinfo
I substituted all the M code lines and it works again 🙂