Dataflow import to existing table

[Anonymous]

Hello,

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 ErrorThe columns are loading the whole time and don't finish

Works with campaign-table:

It works in a smaller table like "campaign" 

Best regards,

Florian

[EricRegnier]

Hi @Anonymous,

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: https://admin.powerplatform.microsoft.com/support
Hope this helps! 

[Sunidhigambhir1]

Hello,

Sign in to Power Apps>>On the left navigation pane, select the
option i.e. Data>>
in the Data list, select Dataflows,
select New dataflow, and then select Start from blank>>
On the New Dataflow page enter a Name for the dataflow.
By default, dataflows store tables in Data verse.

Select Analytical entities only if you want tables to be
stored in your organization's Azure Data Lake storage account.
Select Create.
On the Choose data source page, select the data source where

the tables are stored. The selection of data sources displayed
allows you to create dataflow tables.
After you select a data source, you’re prompted to provide the
connection settings, including the account to use when
connecting to the data source. Select Next.

Once connected, you select the data to use for your table.
When you choose data and a source, the Power Platform Dataflow
service will subsequently reconnect to the data source in order
to keep the data in your dataflow refreshed, at the frequency
you select later in the setup process.
Now that you've selected the data to use in the table,
you can use the dataflow editor to shape or transform that data
into the format necessary for use in your dataflow.

[Sunidhigambhir1]

Hello,

Sign in to Power Apps>>On the left navigation pane, select the
option i.e. Data>>
in the Data list, select Dataflows,
select New dataflow, and then select Start from blank>>
On the New Dataflow page enter a Name for the dataflow.
By default, dataflows store tables in Data verse.

Select Analytical entities only if you want tables to be
stored in your organization's Azure Data Lake storage account.
Select Create.
On the Choose data source page, select the data source where

the tables are stored. The selection of data sources displayed
allows you to create dataflow tables.

After you select a data source, you’re prompted to provide the
connection settings, including the account to use when
connecting to the data source. Select Next.

Once connected, you select the data to use for your table.
When you choose data and a source, the Power Platform Dataflow
service will subsequently reconnect to the data source in order
to keep the data in your dataflow refreshed, at the frequency
you select later in the setup process.
Now that you've selected the data to use in the table,
you can use the dataflow editor to shape or transform that data
into the format necessary for use in your dataflow.