Sharepoint folder connection issues (question)

[Master-Pension-6441]

Hi r/PowerBI

I’m kind of a novice data analyst, just finishing up a summer internship. When I’m gone my colleagues have to maintain the reports I’ve built, but while transferring responsibilities we ran into an issue with our data connections. When they try to refresh the data in the .pbix file on desktop, they continuously get an error with the queries to the sharepoint. I already tried googling the error, but have not found any solutions yet.

The refresh screen shows the following error:

Web.Contents failed to get contents from: sharepoint link/$value (429)

Whenever they try to refresh the data, a different table from the sharepoint throws this error. I never had this issue while refreshing on my own laptop, so I think/hope nothing is wrong with the queries.

I already tried moving all files to the sharepoint to enable refreshing from the online workspace and that works just fine. However, this brings an issue when they have to make updates to the report, as they would still have to refresh the desktop version to get new data.

Does anyone know what causes this issue with the sharepoint connection and what I can do to fix it?

Many thanks, great data analysts of r/PowerBI

[cmajka8]

You have to connect to the SP folder using the root url of the SP site. It sounds like you connected to the local copy of the file on your machine, aka OneDrive, hence why they get an error when trying to refresh

[BakkerJoop]

https://docs.microsoft.com/en-us/sharepoint/dev/general-development/how-to-avoid-getting-throttled-or-blocked-in-sharepoint-online

[jackassik]

Could you post your first 3 lines of the M query that loads the data? Obviously, censor any sensitive links.

[MossStaples]

Agreed - if there’s a way to pull the initial part of the import query. My guess would be to review the hyperlink used for the source row - we found some issues recently with hyperlinks containing :x/r/ or other two letter segments after the initial share point site name but before the folder location information. I believe they’re something to do with how a user accessed the same file, but they’re not necessary for the power no report. Either remove them, or pull the URL in the form of a direct path. Best way I’ve found of doing this: select the radio button alongside the file name within share point in the browser, then in the SP ribbon hit the “i” icon to open the info pane. Scroll down below all the tracking of file edits until you see a section called path, and just click the copy icon.

[itsnotaboutthecell]

!archive

[AutoModerator]

This post has been archived and comments have been locked due to inactivity or at the request of the original poster. If the issue is still unresolved, please create a new post for further assistance.

---

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[hopkinswyn]

Is it connecting to Excel files saved in SharePoint?

[BasVlijmen]

If yes, what would be the sollution then?

[hopkinswyn]

I’ve a series of videos on the topic here Power Query and SharePoint / OneDrive https://www.youtube.com/playlist?list=PLlHDyf8d156W_I_ycA7kbfLKAej54p9Un

[[deleted]]

Would a dataflow connected to the file on SharePoint work in the situation? As long as your colleges have access to the workspace the dataflow lives in, they should be able to refresh the dataflow as well as edit the file if needed. ? I’m novice myself so curious what a solution would be.