Supply chain | Supply Chain Management, Commerce

Export data from data entity if the number of records are more than 1 million

(0) Share

Report

Posted on by Manufacturing

156

We have a requirement to export the data for more than 4 million/40 lakh records from single entity and we don't have any option to filter the data in entity settings based on Item number and certain number of records. How can we extract those ?

All responses (3)

Answers (0)

Suggested answer

Mohamed GRAIB 2,494 Super User 2025 Season 1 on at

Like (0)

Report

Export data from data entity if the number of records are more than 1 million

Hi,

You can export to Azure data lake if you want,

can you follow this link ?

Export to Data Lake in finance and operations apps - Finance & Operations | Dynamics 365 | Microsoft Learn

About Power BI, you don't need to export to Excel Firstly,
We have an out of the box connector,
Just open Power BI desktop, then click to obtain data and in the data source you can select Dynamics 365 ERP

Hope that's help
Manufacturing 156 on at

Like (0)

Report

Export data from data entity if the number of records are more than 1 million

Hi Graib,

Thanks for your response.

But I could see below extensions in my data management n dont see the ones that you suggested.

If we extract it from UI to BYOD(Azure) or Power BI how we are going to extract it to Excel back again ?
Suggested answer

Mohamed GRAIB 2,494 Super User 2025 Season 1 on at

Like (0)

Report

Export data from data entity if the number of records are more than 1 million

Hi,

You can export get them via Power query (Power BI) Or, you can export them to SQL Azure (Byod).

I think that Excel and csv format are limites.

Regards,

Hope that's helpful.

please mark answer as verified if that's help