Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Dataflows in a Managed Solution

(0) ShareShare
ReportReport
Posted on by 72

Hello all,

 

I have 3 dataflows (reading from SQL database and writing into Dataverse tables) in the solution.

When I have moved the solution from Dev to Test, it became managed solution. I see dataflows in the solution but they are with Status "Off" and no data coming through them to the tables.

 

P.S. Dataflows are set refresh automatically every 30 minutes (in the DEV environment settings).

 

Please, advise on what I can do?!

 

Thank you in advance,

Alexandra

  • NerdingNate Profile Picture
    42 on at
    Re: Dataflows in a Managed Solution

    Check out what Andrew Elans posted here: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataflows-missing-from-list-but-still-exist-and-run/td-p/1641223

     

    That should resolve the issue. Sidenote, I found that I had to completely remove the solution that contained the dataflows to make this work. 

  • scottcombs Profile Picture
    6 on at
    Re: Dataflows in a Managed Solution

    Hi @ArisTale

    We encountered not being able to open a dataflow after it was promoted to Test in a managed solution.  The dataflows were owned by the admin after being promoted.  After changing the dataflow owner back to the user who created them, the edit option was enabled for the user and they could change the credentials as shown above by @EricRegnier.

    The change owner option was difficult to locate.  After Dataflows is selected from the left nav menu, the change owner option is on the All Dataflows tab, under "..." shown below.  Hope this helps.

    scottcombs_0-1695128990008.png

     

  • ArisTale Profile Picture
    72 on at
    Re: Dataflows in a Managed Solution

    https://learn.microsoft.com/en-us/power-query/dataflows/dataflow-solution-awareness

    This is a very good explanation on HOW to deal with dataflows during export/import BUT in my case dataflows don't appear at the Dataverse - Dataflows in the end environment. They sit only in Solution from where I can't open them and proceed with "connections"... 

  • ArisTale Profile Picture
    72 on at
    Re: Dataflows in a Managed Solution

    .

  • ArisTale Profile Picture
    72 on at
    Re: Dataflows in a Managed Solution

    No Cloud Flows - Dataflows - but inside Soultion.

  • ArisTale Profile Picture
    72 on at
    Re: Dataflows in a Managed Solution

    Hello Eric,

     

    I don't get you.

    I have dataflows in Env 1 and they are part of the solution I am going to move as managed solution into Env 2.     There, in the Env 2, my dataflows are NOT visible in the folder under Dataverse - Dataflows. They are visible inside solution as Cloud flows but they are not working - not bringing me data. I want them to work. Can you describe how to enable them in more details?!

     

    Best regards,

    Alexandra

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on at
    Re: Dataflows in a Managed Solution

    Hi @ArisTale,

    This is as designed behavior because you'll need to setup the connection before it can be turned on. To do this, in Maker portal go to Dataverse --> Dataflows --> select your Dataflow --> click Edit in the ellipse then a notification will popup to configure the connection like the image below. Save all and publish at the end.

    EricRegnier_0-1672691811130.png

    Hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics