Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Syndicate_Admin
Administrator
Administrator

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

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 )

Syndicate_Admin
Administrator
Administrator

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!

Syndicate_Admin
Administrator
Administrator

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

Syndicate_Admin
Administrator
Administrator

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?

v-kelly-msft
Community Support
Community Support

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.