Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Dynamics Public Sector (North America) - Forum / Dynamics Public Sector...
Dynamics Public Sector (North America) - Forum

Dynamics Public Sector (North America)

(0) ShareShare
ReportReport
Posted on by JW-16081432-0 65

Montgomery County is looking into utilizing Power BI as a reporting tool.  Out of the box Dynamics only allows you to hit data in prod via an ODATA feed.  Only data entities listed can be utilized for reporting.  Not all areas / modules have data entities to report against, for example posted AP Invoices.  In order to hit the production database directly we will have to purchase Data Lake or Synapse.  

Are there any other public sector clients utilizing Data Lake or Synapse?  It's my understanding that Synapse is just a service that allows you to hit the production database for tables with change tracking turned on.

  • CU24101537-0 Profile Picture
    CU24101537-0 45 User Group Leader on at
    RE: Dynamics Public Sector (North America)

    We are looking at building Azure Data Lake this summer as a project and then a public portal to share Revenue, PO, and expenses for public access/public records requests. 

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

Check out the New Agent Creator Community

Leaderboard > Dynamics Public Sector (North America)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans