Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Invalid Credentials When Using Azure Data Lake Storage Gen2 using dataflows in the Service

I am able to connect to Azure Data Lake Storage Gen2 using the connector in Power BI Desktop. However, when I try to use dataflows in the service, I get an Invalid credentials error. I'm using the sa...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

Please check if you meet the following conditions:

 

  • To bring your own ADLS Gen 2 account, you must have owner permissions at the storage account layer. Permissions at the resource group or subscription level will not work. If you are an administrator, you still must assign yourself owner permission. Currently not supporting ADLS Gen2 Storage Accounts behind a firewall.
  • The storage account must be created with the Hierarchical Namespace (HNS) enabled.
  • The storage account must be created in the same Azure Active Directory tenant as the Power BI tenant.
  • TLS (Transport Layer Security) version 1.2 (or higher) is required to secure your endpoints. Web browsers and other client applications that use TLS versions earlier than TLS 1.2 won't be able to connect.
  • Attaching a dataflow with ADLS Gen 2 behind multi-factor authentication (MFA) is not supported.

 

Referencing: Configuring dataflow storage to use Azure Data Lake Gen 2 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi v-kkf-msft

 

Are you saying that there is no way to connect to Gen2 storage (if there is a firewall configured)? My Infosec team is not going to ever remove the firewall for obvious reasons which seems make connecting to Gen2 storage impossible ?

 

Currently we have a Datafactory instance configured as an override and I hoping to add the PowerPlatform override but from what you say this is not possible ?

 

Thanks