Getting Error while accessing with SharePoint

[Sudharshan1919]

Hi All,

I am calling an excel which is placed in sharepoint and developed the report. The URL was accessed fine and i have deployed the report. Recently after 2 months, i got an error in my report while accessig that same sharepoint URL. Error as per below screenshot.

Kindly help me to sort out this issue

Thanks,

[bilalrana]

@Sudharshan1919 

Are you using the URL from when you open the file in the desktop app?  The one that ends in ?web=1 (that you delete).

In any case, use the SharePoint folder connector instead, replacing @ and . in your email.

Yes.  That happens sometimes with some sources.  To get there in this case, go to the query editor and start a new blank query.  In the Formula Bar (check the box in View tab if you don't see it) and write the first line of your query like = Web.Contents("<your url>") 

You should then get the error but also a button you can click to Edit Crendentials for that source.

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!