Issues importing lists from a sharepoint in power bi desktop

[humbrolo]

Hello team, I'm trying to import two lists from SharePoint to create a dashboard. However, when I enter the address of the SharePoint list, I'm unable to do so. I was able to do this before, but after I deleted a report and the querys I had made, I can no longer load my lists from SharePoint. This is the result I get when I try

[danextian · Accepted solution]

Hi @humbrolo 

What do you see you use this formula?

= SharePoint.Tables("https://myorg.sharepoint.com/sites/testsite/", [Implementation="2.0", ViewMode="All"])

You should be able to see the lists from that sharepoint site that have you access to.

If not, it could be a permission issue.

[humbrolo]

Thank you very much with that formula i could locate all the lists!! i dont know why did they disappear, but it was so helpful!!

[AmiraBedh]

If connecting directly to a list, make sure the URL includes the /Lists/ListName path.

Power BI might be caching old data or credentials so try to clear the cache.

Sometimes changes to the structure of your SharePoint list, such as added/removed columns or changed data types, can cause type mismatches so you may need to review the SharePoint list schema and check if all columns have compatible data types.