cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
khoait
Advocate I
Advocate I

Failed to import dataflows to a target environment

Hi,

 

I'm trying to import a solution (managed/unmanaged) containing 26 dataflows, the import process fails every time I try. The error log is not very helpful, it says "A task was canceled."

 

khoait_0-1632936397583.png

 

I think the problem is because each dataflow takes too long to publish in the target environment causing the import process to timeout.

 

I'm kind of stuck now. I don't want to deploy each of them separately or recreate them in the target environment.

 

Much appreciated if anyone can point me in the right direction!

 

 

8 REPLIES 8
Syndicate_Admin
Administrator
Administrator

Hi  @Syndicate_Admin ,

 

Do you import the dataflows in desktop or Service?

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Hi Kelly,

 

I'm using Dataflows in Power Platorm Maker Portal. I created a solution and include the dataflows, and import the solution to the target Power Platform environment.

 

I tried to split a single dataflow to a separate solution. And it imported successfully. The error happens when I have two or more dataflows in a solution.

 

Kind regards,

 

Khoa

Hi  @nhnkhoa ,

 

Will it be the reason that the dataflows in a solution have multiple credentials?

As for dataflow,there is a limitation as below:

  • Dataflows using gateway data sources do not support multiple credentials for the same data source

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitations

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Hi Kelly,

 

I'm not using data gateways in my dataflows and only use my credentials to connect to Sharepoint folders.

 

If it is the case, it should also fail when I imported one dataflow separately. However, the solution containing only one dataflow imported successfully.

 

Kind regards,

Khoa 

RuneHanssens
Frequent Visitor

Any updates on this? I have the same issue but I only have 1 dataflow so I can't split them up in multiple solutions. Is there a way to increase the time before a timeout occurs?

Wobbler100
Regular Visitor

Any update on this I am having the same issue, only element in the solution is the Dataflow and it is not using multiple connections

khoait
Advocate I
Advocate I

Hi @RuneHanssens , @Wobbler100 ,

I tried again today and it worked for me with 16 dataflows in a single solution. I'm not sure if it's just luck this time or the issue has been fixed.

Hope it works for you as well!

alexsolex
New Member

Hello @khoait 

Do you know if you are responsible for this finally success ? 
I tried so many things to import dataflows to another environment without any luck 😞 Every attempts failed like you showed in your screenshot but I can't find why. Any help is welcome !
(here is recent article that explains how it is supposed to work : https://docs.microsoft.com/en-us/power-query/dataflows/dataflow-solution-awareness )

Helpful resources

Announcements
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.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Top Kudoed Authors
Users online (1,892)