Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 2,437
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:
Business Central
  • CU29041409-0 Profile Picture
    CU29041409-0 37 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.
  • Community member Profile Picture
    Community member 22 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.
  • Suggested answer
    Community member Profile Picture
    Community member 2 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 22 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
    gdrenteria Profile Picture
    gdrenteria 12,183 Most Valuable Professional on at
    PBI API connection on the fly define read-access
    Hi
    Here some information, I hope this can help you. 
    BR
    Gerardo

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans