Issue accessing dataflow on PBI Service even when I am admin

[meowster]

I have created a workspace with my colleague and I as admins. She has created a Gen 1 dataflow connected to Redshift Serverless.

However, I am unable to access the dataflow on PBI Desktop or see any attributes from the dataflow.

Any help is greatly appreciated!

[v-mdharahman]

Hi @meowster,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are facing permission issue with the Dataflow in PowerBI Desktop. As @meowster responded to your query, please go through his response and mark it as solution if it answers your query.

I would also take a moment to thank @Akash_Varuna, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[v-mdharahman]

Hi @meowster,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[meowster]

Hi @v-mdharahman,

Thank you for following up. I have yet to find a solution for this issue.

[v-mdharahman]

Hi @meowster,

Can you please tell which part of the problem you are struck in right now or the original question is still unanswered.

Thank you.

[meowster]

Hi @v-mdharahman, the original answer is still unanswered. The solutions provided by @Akash_Varuna are unable to solve my issue unfortunately.

[Akash_Varuna · Accepted solution]

Hi @meowster Could you check this forum
https://community.fabric.microsoft.com/t5/Power-Query/dataflow-permission-to-access-issue/td-p/19967...
In this they have mentioned that the dataflow ownership may need to be changed could you go thorugh this maybe it might be helpful for you

[meowster]

Hi @Akash_Varuna, this works. Seems like whoever with admin access to the workspace would need to take over the ownership of the dataflow in order to access it via Power BI Desktop. Although it doesn't seem to be the best permanent solution, we would have to make use of this for now. Thank you!

[Akash_Varuna]

Hi @meowster The issue might be of number of reasons could you check for these please

• Verify you have explicit permissions to access the dataflow.
• Confirm you're signed in with the correct account in Power BI Desktop.
• Clear the cache in Power BI Desktop by navigating to File > Options and Settings > Options > Data Load > Clear Cache.
• Ensure the dataflow is published and refresh is successful.
• Confirm Redshift credentials are properly configured in the dataflow.
  If this post helped please do give akudos and accept this as a solution
  Thanks In Advance

[meowster]

Thank you @Akash_Varuna, I've tried all except the first "Verify you have explicit permissions to access the dataflow". The dataflow owner is unable to explicitly give me permission as there is no selection to do so. How do I explicitly give permission?

[Akash_Varuna]

Hi @meowster Could you check on the workspace level if it is not available there could you contact your admin

[meowster]

I am the admin for this workspace. Do I need to toggle some of the settings?