web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
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
  • Suggested answer
    Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... on at
    PBI API connection on the fly define read-access
    Hi
    Here some information, I hope this can help you. 
    BR
    Gerardo
  • Community member Profile Picture
    Community member on at
    PBI API connection on the fly define read-access
    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 on at
    PBI API connection on the fly define read-access

    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 on at
    PBI API connection on the fly define read-access
    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 on at
    PBI API connection on the fly define read-access
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans