Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Developing an Online Portal for Data Ingestion/Entry

(0) ShareShare
ReportReport
Posted on by 15

Hello. I'm very new to Microsoft Power Apps in general, and I would like some direction regarding a task.

I have a project that is asking of my team to develop an online portal for data ingestion/entry. Basically, data (Excel files, potentially other sources later as well) is fed through the portal, entities are created from the Excel datasheets in Dynamics 365, and then Power BI reads from D365 as a data source and dashboards can be created. Also need to define user groups and roles for data input through the portal. The project is already using CRM dynamics 365 so we need to build over it the required entities to feed to the dashboard. How would I best approach this? We can use any Power App available or utilize Dataverse.

Another question as well. How do you exactly link D365 with Power BI? Do you just use the url or do you need some sort of API url?

From my research, I saw that Power Automate might help. Also came across web Portals in Power Apps. I'm stuck and documentation is very confusing so anything can help. A workflow or reference would also be appreciated. 

Thank you all. 

Apologies if my post isn't in the right topics or filters. 

  • NaCarns Profile Picture
    15 on at
    RE: Developing an Online Portal for Data Ingestion/Entry

    Hello. Thanks for the reply. This does answer the last part of my question, so thank you for the reference.  

  • Suggested answer
    Nya Profile Picture
    29,058 on at
    RE: Developing an Online Portal for Data Ingestion/Entry

    Hi,

    Power BI is mainly used to generate some reports in Dynamics.

    Here is an article which is a tutorial about how to use Power Bi in Dynamics which may help you.

    Creating PowerBI Report with Dynamics 365 - Top Microsoft Dynamics and NetSuite Partner & Dynamics CRM Consultant in San Diego (alphabold.com)

     

    If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

    Best Regards,

    Nya

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,296 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,093 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans