cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
3of5
Regular Visitor

Dataflow import to existing table

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 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,

Florian

3 REPLIES 3
EricRegnier
Super User
Super User

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

Sunidhigambhir1
Helper II
Helper II

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.

dataflow1.png

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.

Screenshot (333).png

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
Helper II
Helper II

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.

dataflow1.png

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.

Screenshot (333).png
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.

Screenshot (335).png

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.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,894)