How do I connect to entity data using power automate? What are my options

(0) Share

Report

Posted on by naijacoder

Hi there,

I'm pretty very new to the Dynamics 365 space.

I have a Dynamics 365 Finance and Operation module setup and I would like to retrieve some data in the entities.

Can I use excel to get the data?If yes how
Can I use power automate? If yes what connectors are available?

I have been given some app registration details e.g client secret/id etc..

But how do I use them?

Any suggested tool I can use to test the connection would be great

Thanks in Advance

I have the same question (0)

All responses (5)

Answers (0)

Martin Dráb 236,513 Most Valuable Professional on at

Like (1)

Report

RE: How do I connect to entity data using power automate? What are my options

1) Yes, you can Excel, e.g. by using Data management workspace to export data to an Excel file.

2) Yes, you can use Power Automate. You can use the native F&O connector, or other APIs (namely data management APIs to export data to Excel, if that's your goal).

Was this reply helpful? Yes No
André Arnaud de Cal... 299,415 Super User 2025 Season 2 on at

Like (1)

Report

RE: How do I connect to entity data using power automate? What are my options

Hi naijacoder,

In addition to the reply from Martin, you can also setup the data entities as virtual tables in Dataverse and then use the Dataverse connector.

Was this reply helpful? Yes No
naijacoder 38 on at

Like (0)

Report

RE: How do I connect to entity data using power automate? What are my options

Thanks Martin for you reply. It was really helpful

One other question is if i want to create connection(read only entities/tables) to Power BI what would be the best way to setup this connection and what do I need?

We are also thinking of connecting it to some other BI tools.

I can't seem to find any resource around integration etc..

Thanks in advance

Was this reply helpful? Yes No
André Arnaud de Cal... 299,415 Super User 2025 Season 2 on at

Like (1)

Report

RE: How do I connect to entity data using power automate? What are my options

Hi naijacoder,

You are now changing the topic of the original question. Please create new posts for new questions. Mixing up topic might be confusing for any other member on this forum.

When you want to use Power BI, then you should consider moving data to Azure Data Lake or BYOD first:

Export to Azure Data Lake overview - Finance & Operations | Dynamics 365 | Microsoft Learn

Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
naijacoder 38 on at

Like (0)

Report

RE: How do I connect to entity data using power automate? What are my options

Thanks for the reply.

Also I will create a new post if I have any other questions

Was this reply helpful? Yes No

Join the conversation

Community site session details

How do I connect to entity data using power automate? What are my options

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

How do I connect to entity data using power automate? What are my options

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates