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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Users online (2,524)