Showing results for 
Search instead for 
Did you mean: 
New Member

Dataflow import to existing table


we are using Power Apps with the Dynamics 365 Sales Enterprise License.


I am trying to import some records in the Dynamics Lead Entity.

The whole PowerQuery tranformation ist working, but the mapping to the table-columns fails with an unexpected error.

I can create a new table and i also can to choose to use an existing table. Most of the existing tables are working except the lead-table. I also tried opportunity, contact and account, they are also not working, but a smaller table like campaign does work.

These are the table with the most columns in Dynamics, is there a limitation, for importing records only in small tables?


Error by using lead-table:

Unexpected ErrorUnexpected ErrorThe columns are loading the whole time and don't finishThe columns are loading the whole time and don't finish


Works with campaign-table:

It works in a smaller table like "campaign"It works in a smaller table like "campaign" 


Best regards,


Super User II
Super User II

Hi @3of5,

No there's no limitation on table with lots of columns or on out-of-the-box D365 tables. Have you tried in other browser like Edge or clearing all your cache? If the problem persit I suggest to lodge a Microsoft support ticket at:
Hope this helps! 

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,530)