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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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,319
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... 27,280 Most Valuable Professional on at
    Hi
    Here some information, I hope this can help you. 
    BR
    Gerardo
  • CU27040855-3 Profile Picture
    CU27040855-3 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
    CU27040852-14 Profile Picture
    CU27040852-14 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.

  • CU27040855-3 Profile Picture
    CU27040855-3 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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May 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,869 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,182 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,109 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans