cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sudharshan1919
Helper II
Helper II

Getting Error while accessing with SharePoint

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.

Sudharshan1919_0-1660892511695.png

Kindly help me to sort out this issue

 

Thanks,

1 REPLY 1
bilalrana
Resolver I
Resolver I

@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!

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.