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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.