web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / User table for use in ...
Microsoft Dynamics CRM (Archived)

User table for use in Power BI

(0) ShareShare
ReportReport
Posted on by Mark WHE 91

After reading this article, i found i could make huge time savings on refresh of my Power BI reports.

However i am stuck with Users. In the data source (...../api/data/v9.1/) I do not have a table that contains the UserID and users names. Several 'User' tables but none have a real name, they all contain related tables alongside the ...userID_value.

 

Am i missing something here? 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mark WHE Profile Picture
    Mark WHE 91 on at

    Sorry, ignore this. I just loaded the SystemUsers table (that shows in preview as only being a list of related tables) and it has the names.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans