Data Connection Error

[ConnorH]

Please direct me to the correct forum if I am posting in the wrong place. I have a table called 'Project Video' which I connect using the sharepoint folder then connecting with the base link to the Online Sharepoint List then import the list. I have not had any issues with this table up until recently. This table is connected to many other tables and I need to expand the 'Projects' table to pull in a ProjectID column so I can connect it to my 'Projects' table. But there is an error now in many of these connections and I don't know what has happened. I primarily work on the Power BI side of things and there is a separate team that works with all the sharepoint sites. Could this issue may maybe be caused from the other team?

[PhilipTreacy]

Hi @ConnorH 

What are the actual error messages?

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[ConnorH]

I have attatched two images. I expand project and add in the project ID column then apply changes and get the first image. When I click view errors it creates a query which is what the second image is.

[PhilipTreacy · Accepted solution]

Hi @ConnorH 

What I meant was if you filter the column(s) to keep Errors, or just scroll down the table to find one, you can then click on one of those errors and see what the actual error message is.

Phil

[ConnorH]

I am going to just accept your last comment as a solution because after scrolling down through the Project ID column that I expanded I found 3 errors and was able to trouble shoot it from there. Turns out someone deleted the project but there was a row in a different table that was not deleted which caused errors between the table connections. Thank you!