You’re offline. This is a read only version of the page.
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
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. "
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (