Forum Discussion
Dataflow gen2 tables not listed in navigator
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
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
10 Replies
- suparnababu8
Super User
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
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!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!
v-achippaCommunity Support
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
