Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ConnorH
Microsoft Employee
Microsoft Employee

Data Connection Error

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?Error.PNG

1 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

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

4 REPLIES 4
PhilipTreacy
Super User
Super User

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.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


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.

 

Error 1.PNGError 2.PNG

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

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


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!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors