Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Create View in CRM DB SQL with Microsoft SQL Server

Posted on by 121

Hi everyone,

I'd like to create a View into D365 SQL from Microsoft SQL Server.

The obtained view contains data for PowerBI develop with some filters for BU.

If my user (system administrator) open this db from DBMS have read only access...

I asked you confirm if it's possible to create it or not.

Thanks in advance.

Silvia Innamorati

  • Suggested answer
    RE: Create View in CRM DB SQL with Microsoft SQL Server

    Hello Silvia,

    Hope you are well.

    I'm not sure i have enough context to help you but will try.

    A CRM user even with system administrator role, when trying to login to SQL will always only be able to READ filteredviews. These views are used for reporting /excel etc.

    If you need to Create  views on CRM DB, your login needs a specific SQL role, such as DBowner or similar.

    Still, creating views on a CRM DB directly on SQL is unsupported, and should not  be performed:

    learn.microsoft.com/.../supported-extensions

    "Modifications to the physical schema of the database, other than adding or updating indexes. This includes any actions performed against the database without using the System Customization capabilities in the web application or using the metadata APIs that are described in this SDK documentation. Modifying tables, stored procedures, or views in the database is not supported. Adding tables, stored procedures, or views to the database is also not supported because of referential integrity or upgrade issues. "

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans