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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Retreiving and processing data from Dynamics 365 F&O based software

(1) ShareShare
ReportReport
Posted on by 6

Hi community,

I'm researching the ways to retrieve and process large datasets from several tables. I was forwarded to this forum from regular Power Apps comunity but originally I  was thinking if it was possible with using Dataverse using Power Automate and Power Apps. The tables are quite large, containing millions of records with complex relationships and the data is retrieved from Dynamics 365 and based on Dynamics 365 official accountant software(HI-KORT). The main purpose is retreiving data and conduct checking this data with dates of checking and PIC name and possible print or save as csv/Excel file. 

Requirements:

  1. Efficient data retrieval and processing.
  2. Ability to handle large volumes without significant performance issues.
  3. Output the processed data into Excel or CSV format
  4. Avoiding extra costs on licenses and premium connectors

I wonder if it is possible without usage of premium connectors and BI and if there is a need of special permissions and security roles for each user who is accessing the app.

 

The data is in D365 FO/HI-KORT and we want it to be accessible from Power Apps (or alternatives) so we can read and add some information to new (not existing in the original tables) columns who and when checked the records. There are several tables and not all of them related. Currently the checkings are via Excel and it is quite bulky that is why we would prefer more advanced way with filtering and such available on daily basis. So the tables would be accessed every day up to several times by several users. 

 

 Will be grateful for all your kind ideas and suggestions but thank you for your consideration as well. Wish you a pleasant day!

I have the same question (0)
  • Anthony Blake Profile Picture
    3,070 Super User 2026 Season 1 on at
    Hi, how often do you need this data, as a one off or at regular intervals?
  • Waed Ayyad Profile Picture
    9,073 Super User 2026 Season 1 on at
    Hi,
     
    Are the data relating to standard tables? Do you want to integrate the data with D365 FO?
     
    Thanks,
    Waed Ayyad
  • asa9 Profile Picture
    6 on at
    Thank you for your kind reaching out! My apologies for the late reply!
     
    The data is in D365 FO/HI-KORT and we want it to be accessible from Power Apps (or alternatives) so we can read and add some information to new (not existing in the original tables) columns who and when checked the records. There are several tables and not all of them related. Currently the checkings are via Excel and it is quite bulky that is why we would prefer more advanced way with filtering and such available on daily basis. So the tables would be accessed every day up to several times by several users. 
     
    I am new on the forum and failed to find a reply button to the replies so I hope this message will reach you. I will add it to the original post just in case. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 386

#3
Adis Profile Picture

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans