Access Dataflow Table

[Ish2k]

Can I access data in a dataflow gen 1 table with a free subscription in a premium organization?

How can I connect and query this table from Power Automate Flow?

[Anonymous]

Hi,

Thanks for the solution jennratten  offered, and i want to offer some more information for user to refer to.

hello @Ish2k , based on your description, please make sure you have the related permission of the dataflow,  you can refer to the following link about it.

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-configure-consume#con...

If the solution jennratten  and i offered help you solve the problem, you can consider to accept them as solutions so that more user can refer to.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jennratten]

Hello @Ish2k - users with free licenses can only create a dataflow gen1 if done in a workspace that is assigned to a premium capacity.  Based on your description, it sounds like that may be applicable to you.  The only action for dataflows from Power Automate is to refresh the dataflow.

[Ish2k]

Hello @jennratten 
Thank you for your response. When I try to access a table in an existing dataflow, I get an error saying " There was a problem opening your dataflow. You do not have permissions to manage this dataflow"
Is there a way where I can access the table with my current access?

[jennratten]

Hi @Ish2k - if you are trying to access the dataflow by opening/editing it in the workspace, then you must be the owner of the dataflow.  If you are not the owner then you can take over the dataflow by going to the dataflow settings and click 'take over'.  A word of caution though - be sure you have access to all data sources/gateway connections the dataflow uses or else the dataflow will be broken.  If you are simply trying to use the data a table contains, you can connect to the dataflow table using Power Query.