Credential issue with ADLS gen2 where power bi and storage account not in same tenant

[pkn7]

Hi Team,

Power bi report with ADLS gen2 datasource is able to retrive data locally from desktop without any issues. But once its published to service, we are getting credential invalid error. How to configure the credentials from different tenant than power bi .Any help is much appreciated.

Thanks,

Priyanga

[Anonymous]

Thank you for caring about this case @Anonymous , and allow me to provide another insight:

Hi, @pkn7 

You're using the ADLS Gen 2 connector in Power BI Desktop, and you'll need to set up a dataflow for your report in Power BI Service, and continue to use this linker in this dataflow:

For detailed tutorials, you can refer to the official documentation below:

Azure Data Lake Storage Gen2 - Power Query | Microsoft Learn

In addition, there is a method of connection. One way to do this is for you, your tenant, and your workspace settings:

For a more detailed tutorial, you can refer to the official documentation below:

Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Learn、

Before attempting to connect, you need to fully understand the limitations described in these two documents and set them according to your actual situation.

Best Regards

Jianpeng Li

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

[pkn7]

Hi @Anonymous ,

In the second solution, Connect to an Azure Data Lake Gen 2 at a workspace level, looks like it will work only when Power BI and ADLS are in the same tenant. In our case both Power BI and ADLS are in different tenants.

WRT first solution, Connect to Azure Data Lake Storage Gen2 from Power Query Online, we already have developed the report from desktop application(its a huge report). Do i need to create the report again in power bi service? Also Will this approach work if Power BI and ADLS in different tenant?

Thanks,

Priyanga

[Anonymous]

Hi, @pkn7 

You don't need to redesign your report. You only need to add one cloud connection and select Gen2, as shown in the following figure:

Best Regards

Jianpeng Li

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

[pkn7]

Hi @Anonymous ,

I tried as you have suggested above. But I am getting the below error.

Unable to update connection credentials. Your credentials may be invalid. You may not have permission on the data source or the data source may have additional security enabled such as a firewall.

Thanks,

Priyanga

[Anonymous]

Hi, @pkn7 

As super user said, have you tried using a gateway to connect to your ADLS gen2?
Whether the credentials you used to create the gateway connection are the same as the credentials you used in the desktop, including the authorization verification method.

Best Regards

Jianpeng Li

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

[pkn7]

Hi @Anonymous ,

Thanks for you your time for the detailed explanation. I will go through the links and get back if have any queries

Thanks,

Priyanga

[Anonymous]

You might have to use a Data Gateway to store the credentials for connecting in the service.

[pkn7]

Hi @Anonymous ,

To use Gateway to connect ADLS, do you mean to setup a data gateway in the same way we will setup for on-prem data sources and configure the gateway in the dataset?

Thanks,

Priyanga

[Anonymous]

yes