Dataflow gen2 tables not listed in navigator

[toettoet]

Hi everyone,

I recently set up Fabric in my organization, mainly to benefit from the extra features in Dataflows.

I set up a workspace containing 1 dataflow gen2 that queries a SQL database (through On-Premises data gateway) and a public API. This results in 5 tables.

When I try to 'Get data' from this dataflow in Power BI desktop, everything seems to be working fine: 

But when other users (Viewer/Admin/Member) try to query it, the tables are not listed: 

As a temporary solution, I created a gen1 dataflow in the same workspace using the gen2 dataflow as a linked table.

This works fine and the consumers can see the tables.

What am I missing?

Thanks alot in advance!

Best regards

[v-achippa]

Hi @toettoet,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @suparnababu8 for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @toettoet,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[suparnababu8]

Hello @toettoet 

- Check if there have been any recent updates to the dataflow settings or workspace setup.

- Make sure users have the right permissions in the workspace. Even if they are set as Viewer, Admin, or Member, there might be extra permissions needed to access Dataflow Gen2 tables.

- Refresh the dataflow and update the schema. Adding a new column, even a fake one, and then refreshing the dataflow might help make the tables appear.

If you need more info pls go through below URLs. It might helps you toresolve your problem.

Users unable to connect to Dataflow Gen2 tables - Microsoft Fabric Community

Solved: Tables missing when connecting to dataflow from PB... - Microsoft Fabric Community

Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Lea...

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[toettoet]

Dear @suparnababu8,

Which permissions do you mean by 'there might be extra permissions needed to access Dataflow Gen2 tables'? 

Best regards

[suparnababu8]

Hi @toettoet 

Extra permissions means, it could be like Environment Maker, Basic User and System Customizer. 

Please go through this documentation Security roles and permission levels in standard dataflows - Power Query | Microsoft Learn it  might helps you

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[toettoet]

Dear @suparnababu8 

These roles apply to creating or refreshing a dataflow. I want my users to consume the dataflow in Power BI, they are configured as 'Viewer' role on the workspace. Why can't they see the tables in the dataflow?

Best regards

[suparnababu8]

Hello @toettoet 

If your user have Viewr permission, they are unable to view the tables. Pls have a look on below snap.

Pls go through this documentation Known issue - Dataflow connector doesn't show dataflows with view only permissions - Microsoft Fabri... You will get teh clarity.

Thank you!!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[toettoet]

Dear @suparnababu8 

Assigning a higher level of permission is not a solution. We have the requirement to assign read access to users without the capabilities of a contributor-role.

Best regards

[v-achippa · Accepted solution]

Hi @toettoet,

Users with "Viewer" permissions on the workspace cannot access Dataflow Gen2 tables in power bi desktop, this behavior is a known limitation of Dataflow Gen2. Higher permissions (Contributor or above) are required to access Dataflow Gen2 tables in power bi desktop.

• If you don’t want to give higher permissions, I suggest to create a power bi dataset based on the Dataflow Gen2 tables, publish this dataset to the same workspace. Assign Read permissions to the required users on the dataset and the users can connect to this dataset instead of the Dataflow Gen2.
• Else since Dataflow Gen1 supports Viewer access, linking a Gen1 Dataflow to Gen2 tables allows users to access the data without Contributor permissions, please use this existing one.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @toettoet,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa