Forum Discussion
Dataset with Dataflows fail to refresh when authenticate with new account on Gateway Connection
I just wanted to share a finding that has puzzled our team while working with dataflows on Power BI Service. In hope that this can help out others who are facing the same issue. The story has to...
Hi JChai - Ensure that the account used to authenticate the Dataflows connection via the On-Premise Gateway has access (at least Viewer) to all workspaces containing the Dataflows.
It’s crucial that the permissions for the On-Premise Data Gateway and Dataflows connections are aligned with the workspace permissions, otherwise, it can lead to refresh failures, as you experienced.
As part of best practices, always double-check the Workspace permissions for any user or service account used in connection to Dataflows, especially when setting up On-Premise Gateway connections.
Hopefully, this issue will be more visible in the community, and others will benefit from your detailed experience!