Microsoft Lists not showing when trying to import

[sancilleri]

I am trying to import a Microsoft list into Powerbi.

I got 8 lists however only 3 show up when connecting.

Any ideas why this is happening? 

[amitchandak · Accepted solution]

@sancilleri , this not the same issue. But check if the setting in the solution can help

https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-a-Sharepoint-Online-List/td-p/525842

[v-eqin-msft]

Hi @sancilleri ,

Could you please provide some details like screenshots to make your problem clear?

In addition, how about you use the OData feed in Power BI Desktop to connect to the SharePoint list? You can enter the following URL in OData Feed entry, remember to change SITE_URL with the real URL of your site/subsite. 

http://SITE_URL/_vti_bin/ListData.svc 

Here are some similar solutions, hope they could help you a little.

1. Please check if you have input the correct and valid url link, the link should be like pattern below:

https://domain.sharepoint.com/sites/sitename

2. Is there any error message ? Do you use Organizational account for credential?

3. Make sure that you have permission to all contents.

Best Regards,Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@sancilleri , this not the same issue. But check if the setting in the solution can help

https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-a-Sharepoint-Online-List/td-p/525842

[sancilleri · Accepted solution]

@amitchandak After all the link you sent me helped figure out the issue.

I have two accounts and was switching between accounts on the desktop version.

Went into 'Options and settings' and then 'Data source settings' and signed-in again in the root path under global permissions.

Now I can view all the lists.

Thanks.

[amitchandak]

@sancilleri , Thanks for the update. Kudos to you for in-depth research. Also marking this reply as a solution, so that user can get a quick solution. 

[sancilleri]

Thanks @amitchandak however, the suggested post is not solving my issue.