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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / PBI API connection on ...
Small and medium business | Business Central, N...
Suggested Answer

PBI API connection on the fly define read-access

(1) ShareShare
ReportReport
Posted on by Samantha73 3,297
Hi All
Has anyone connected power BI to BC API/Web Service using below where data access intent is defined for the report but the API itself can have read write access
 
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = true])
 
 
The intent is to create generic API that has CRUD but on the PBI access set the data access intent so the query goes to a read-only replica
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,547 Most Valuable Professional on at
    Hi
    Here some information, I hope this can help you. 
    BR
    Gerardo
  • Community member Profile Picture
    Community member 22 on at
    Yes, it's possible to connect Power BI to Dynamics 365 Business Central (BC) API/Web Service using the specified parameters. By setting the "UseReadOnlyReplica" parameter to true, you can direct queries to a read-only replica of the data, ensuring that the data access intent is defined for the report. This allows for a flexible approach where the API itself can have read-write access, while Power BI accesses a read-only replica for reporting purposes.
  • Suggested answer
    Community member Profile Picture
    Community member 2 on at

    Yes, it's possible to connect Power BI to Dynamics 365 Business Central (BC) API/Web Service using the Dynamics365BusinessCentral.ApiContentsWithOptions function, where data access intent is defined for the report while the API itself can have read-write access. This allows for seamless integration and real-time data visualization within Power BI while ensuring the appropriate level of data access control.

    For assistance in setting up this integration or for any consultation regarding Microsoft Dynamics 365 Business Central, you can rely on Sumindex, a premier partner of Microsoft Dynamics 365 Business Central. Sumindex specializes in providing tailored solutions and expert guidance to maximize the benefits of your Dynamics 365 implementation.

    To schedule a free consultation, feel free to reach out to Sumindex at 9871640876 or email them at info@sumindex.co.in. Their dedicated team will promptly get in touch with you to provide the assistance you need.

  • Community member Profile Picture
    Community member 22 on at
    Yes, it is possible to connect Power BI to Dynamics 365 Business Central API/Web Service using the method you mentioned. By specifying [UseReadOnlyReplica = true], you're indicating that the intent for data access is read-only, while the API itself can have read-write access. This allows for creating a generic API that supports CRUD operations, while ensuring that queries made from Power BI access a read-only replica, thus preserving data integrity and performance.
  • CU29041409-0 Profile Picture
    CU29041409-0 35 on at
    Yes, you can connect Power BI to Business Central API/Web Service using the Dynamics365BusinessCentral.ApiContentsWithOptions function with the UseReadOnlyReplica option set to true. This allows you to define the data access intent for the report as read-only while still enabling the API to have read-write access. The goal is to create a generic API with CRUD capabilities, while ensuring that queries from Power BI are directed to a read-only replica for data access.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,857 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,047 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans