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 :
Small and medium business | Business Central, N...
Answered

Read-scale out with Azure SQL - For BC SaaS

(0) ShareShare
ReportReport
Posted on by 3,255

Hi All

Has anyone configured read only database for BC online? as below

demiliani.com/.../

for BC online? The requirement is having Power BI reports read data from a read only replica

Thanks

I have the same question (0)
  • Verified answer
    NAV_with_Narang Profile Picture
    2,294 Moderator on at

    The link mentions that BC SaaS has this property turned on, so it is recommended to use DataAccessIntent property on your read-only queries

    pastedimage1678337738177v1.png

    You can ask a more specific/detailed question if it helps

  • Verified answer
    Steven Renders Profile Picture
    5,672 Moderator on at

    In BC Saas it is automatically configured. That means, your BC tenant/environment/database automatically sopports it.

    What you can do, as a developer, is when you create new APIs (query, page) or reports, is set the DataAccessIntent property to ReadOnly if the intention is to only read, not update, the underlying data.

    Power BI reports that then consume these APIs will automatically be redirected to the online replica.

  • Samantha73 Profile Picture
    3,255 on at

    That's great, but for the benefit of others, we must also state that the feature is only available to BC premium license. Is there any way we can check this in Azure?

  • Suggested answer
    Steven Renders Profile Picture
    5,672 Moderator on at

    Are you sure this is a premium only feature?

    I don't see that mentioned anywhere:

    learn.microsoft.com/.../database-read-scale-out-overview

    You can use the Database Access Intent List page in BC to see how objects are configured to use Read-Scale-Out.

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans