Data source error message for Web/Sharepoint

[Anonymous]

Hi,

Trying to connect monthly excel file from sharepoint and get the following error message;

"Unable to Connect

We encountered an error while trying to connect.

Details: The input URL is invalid. Please provide the URL to the root of a Sharepoint site, or to the service document or entity of its OData Feed (with no query of fragment part)."

I copy and pasted link where the file is stored on sharepoint folder site.

Unless I've not set this up correctly?

Many Thanks

Sophie

[Sarah_Bani_Issa]

Thank u!!

This save me a huge amount of time 🙂

[v-piga-msft]

Hi @Anonymous ,

It seems that the suggestion of parry2k should be helpful.

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[parry2k · Accepted solution]

@Anonymous watch this and it will get you going.