Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |