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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

On Prem CRM and Power BI Licensing question .

(0) ShareShare
ReportReport
Posted on by 5

Would every Power BI user using the  Dynamics CRM data for analytics require  a CRM License . I mean would this be 1-1 between a Power BI user and SQL Server 365 Dynamics CRM access, or can the data be extracted from 365 Dynamics CRM using one user into BI models and Power BI user would only need Power BI license to be able to access the required CRM data . 

Really appreciate any help with this . 

Thanks,

Mitsu

I have the same question (0)
  • Mimi Yoshida Profile Picture
    on at

    For your scenario, you will need Dynamics CRM licenses for all your users as per stated in the licensing guide. The quote from the guide is below. This is regardless of whether it is on-premise or online version.

    Dynamics 365 licenses are required for users or devices that directly input, query, or view data from the Dynamics 365 service. Similarly, Dynamics 365 licenses are required for users or devices that input data into, query, or view data from the Dynamics 365 service through a pooling device. Pooled connections use a non-interactive user account in Dynamics 365 that can access the system but only via the web service layer. Internal users and devices accessing Dynamics 365 data indirectly through a portal or via an API to a separate service must also be properly licensed, regardless of if they are set up as a Dynamics 365 user in the service, for example:

    • Internal users and devices accessing Dynamics 365 restricted data indirectly through a Power Apps must still be properly licensed for Dynamics 365

    • Any user or device that accesses the service, files, data, or content provided by the service that is made available through an automated process requires a Dynamics 365 license

    • The number of tiers of hardware or software between the Dynamics 365 service and the user or devices that ultimately use its data, services, or functionality does not affect the number of SLs required.

  • MItsumadhani Profile Picture
    5 on at

    Really appreciate your response to this . All we are looking to do is to extract information from the filter view  from on prem CRM db  .  It looked like we could use one SQL CAL to do the extract  . Would it still need license for any one who will land up consuming the extracted data  ?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 96 Super User 2025 Season 2

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans