Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Application Insight PB...
Small and medium business | Business Central, N...
Suggested answer

Application Insight PBI report long running queries

(0) ShareShare
ReportReport
Posted on by Samantha73 2,516
Hi All
After enabling Azure application insights and connecting BC (SaaS) production we can see statistics in the Power BI app from MS. Under long running SQL queries and methods we can see web services that are marked as data access intent read only (under data access intent page). My understanding is when a web service is marked as read Only data access intent it goes to a read-only replica of the production database. Should telemetry show these queries as there is no load on the production database? 
example
 
//
Categories:
Dynamics 365 Business Central
  • Samantha73 Profile Picture
    Samantha73 2,516 on at
    Application Insight PBI report long running queries
    According to MS Data Access Intent directs query to read only replica. Now the question is if application insights report from primary database or include readonly replica as well?
    ​​​​​​​\
    For reports, API pages, and queries, the Business Central server can use read-only database replicas on Azure SQL Database and SQL Server. If replicas are enabled, use this property to reduce the load on the primary database. Using ReadOnly might also improve performance when viewing objects. ReadOnly works as a hint for the server to route the connection to a secondary (read-only) replica, if one is available. When a workload is executed against the replica, insert/delete/modify operations aren't possible. If any of these operations are executed against the replica, an exception is thrown at runtime.
    From the client, the property value can be overwritten by using page 9880 Database Access Intent List page.
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,147 Super User 2024 Season 2 on at
    Application Insight PBI report long running queries
    Hi, if you are referring to Access Intent, this has nothing to do with querying. It is just that when you publish it through an external tool, it can only be read-only. In your example, Power BI can only query data but cannot modify it.
    More details:
    Dynamics 365 Business Central: Managing Database Access Intent (Managing write access to APIs from the client)
     
    Hope this can give you some hints.
    Thanks.
    ZHU

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans