Query SharePoint's UserList Table

[AllanT]

Hi all,

I'm trying to query the UserList table that exists in each SharePoit site collection.  The table is visible in MS Access, and I can easily either import or link to the table with Access. 

The top-level UserInformationList is visible from Power BI, and I have successfully connected to that.  However, while all other tables in the site collections are visible, the UserList table doesn't show in Power BI at all.  

Any help much appreciated.

[v-sihou-msft]

@AllanT

What do your mean "UserList" table?

As I know, the hidden user list for each site collection should be User Information List table. When you connect in Access, this table will appear as "User Info" table.