Monday, September 25, 2017

Access Cross Company Entity Data to Power BI through ODATA link in Dynamics 365 for finance and Operations:

1) For Data Access only for user selected company
www.testdax365aos.cloudax.dynamics.com/data/SSCustomLines
2) For Data Access across all company (?cross-company=true)
www.testdax365aos.cloudax.dynamics.com/data/SSCustomLines?cross-company=true
3) For Data Access only for Filter Specific company (?$filter=dataAreaid eq='SS')
www.testdax365aos.cloudax.dynamics.com/data/SSCustomLines?$filter=dataAreaid eq 'SS'

No comments:

Post a Comment

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...