Matt Smith on 02 Jun 2020 22:02:01
When you connect to a Azure Data Lake Gen 2 (ADLSg2) you connect to storage account, then pass in the container and a path.
For example:
https://PowerBIIdeas.dfs.core.windows.net/datalake/example1/
If you then create another connection - this time filtered to:
https://PowerBIIdeas.dfs.core.windows.net/datalake/example2/
This will then duplicate, so you have two connections in the Power BI service and you have to duplicate the credentials.
You do this so you don't query the entire storage account.
To make matters worse, once you publish, you do not see the account name, you just get whitespace.
- Comments (1)
RE: Stop duplicating ADLSg2 connections and display the account name
Yes, this is frustrating. It stores credentials per-file instead of per-source.
It should be like OData where the credentials can apply to a particular "level" -- i.e. root domain, folder, file as described here https://docs.microsoft.com/en-us/power-query/connectorauthentication#set-the-level-of-the-authentication-method