Skip to main content

Power BI

Needs Votes

Power BI Desktop should use the currently logged in account credentials for dataflow connections

Vote (28) Share
John White's profile image

John White on 12 Apr 2019 20:20:47

When connecting to a dataflow in Power BI Desktop, the connection is cached like all other connections. Each connection persists the relevant tokens for their sources. However, when persisting a SQL connection, each database is cached separately, so different credentials can be used with different databases.

However, dataflows will only store the last connection to a dataflow, which makes connecting to dataflows in multiple tenants an arduous process of changeing the data connect options.

Also confusing is the fact that the account switcher control is unrelated to the dataflow credentials, leading to situations where publish shows one set of workspaces, but the dataflow connector shows another.

Having the account switcher credentials tied to the dataflow connection credentials would solve both of these problems.

Comments (1)
John White's profile image Profile Picture

Tue Ibsen Ibsen on 06 Jul 2020 00:03:56

RE: Power BI Desktop should use the currently logged in account credentials for dataflow connections

Totally agree with this idea - Microsoft, please implement this asap!