Power BI Service Refresh of Azure Data Lake Store not working

[siveyjos]

In Power BI Desktop I am able to successfully connect to an Azure Data Lake Store and create a DataSet and Report.  Once I publish the PBIX file to the Power BI Service, I want to schedule a periodic refresh of the data.  When attempting to schedule the refresh, I am asked to reenter the credentials to connect to the Azure Data Lake Store.

When I do, I always get the following error.  I have double (and triple) checked the credentials, and the same credentials work within Power BI Desktop.  Is it possible to do a scheduled refresh of a DataSet within the Power BI Service if the data source is Azure Data Lake Store?

Failed to update data source credentials: The credentials provided for the DataLake source are invalid. (Source at https://xxxxxxx.azuredatalakestore.net/.)Hide details
Activity ID: 6ffea8ee-fef7-4da6-989f-fef533ec903a
Request ID: da9cd9d8-875d-f82f-8dae-f02969a716c4
Status code: 400
Time: Wed Jun 14 2017 15:58:10 GMT-0700 (US Mountain Standard Time)
Version: 13.0.1721.113
Cluster URI: https://df-msit-scus-redirect.analysis.windows.net

[nvijay]

Did this issue resolve as i am also getting exactly same issue as its cross tenant access 

[v-yuezhe-msft]

@siveyjos,

Are you able to refresh the data in Power BI Desktop? Do you use same account to sign in Azure and Power BI Service?


Regards,
Lydia

[nvijay]

Can you please share if there is a solution to this problem?

Should we use API call to resolve this ?

[siveyjos]

Hi Lydia,

Yes, we are able to refresh the data in Power BI Desktop.  We are using the same credentials in the Power BI service.

Josh

[gomino]

I second that! cause I have the exact same problem with refreshing the data from an Azure DataLake through the Power BI web portal, even though it is working fine through Power BI desktop (using the same account)

The credentials provided for the DataLake source are invalid.

ID d'activité:	c4dc7fae-3454-4c9e-8c26-eb97ae4c67eb
ID de demande:	0b8d7af0-fba6-77aa-11d2-c64d3eeabfea
Code d'état:	400
Heure:	Wed Aug 30 2017 22:06:34 GMT+0200 (CEST)
Version:	13.0.2201.191
URI du cluster:	https://wabi-europe-north-b-redirect.analysis.windows.net

[gomino]

This guy seems to have found the reason of the problem -> connecting-power-bi-to-azure-data-lake-store-across-tenants

Basically, it seems that we cannot currently authenticate against an Azure Data Lake Store from PowerBI.com across tenants.

So as far as I understand, maybe associating the office 365 tenant to the azure subscription of the data lake we are trying to connect may solve the problem (steps to follow here). Note that it will clear your azure active directory.
But this is not intuitive at all if it does work.

Please can someone from the PowerBi or Microsoft team explain what's happening here ?

PS: note that the same guy opened a petition to have Microsoft lift this restriction, please add your vote if you want to get things changed  -> https://office365.uservoice.com/forums/264636-general/suggestions/17841250-allow-powerbi-com-to-conn...

[snowdoniafan]

We are also having the same issue.

Is there a plan to resolve?

[siveyjos]

In Power BI Desktop I am able to successfully connect to an Azure Data Lake Store and create a DataSet and Report.  Once I publish the PBIX file to the Power BI Service, I want to schedule a periodic refresh of the data.  When attempting to schedule the refresh, I am asked to reenter the credentials to connect to the Azure Data Lake Store.

When I do, I always get the following error.  I have double (and triple) checked the credentials, and the same credentials work within Power BI Desktop.  Is it possible to do a scheduled refresh of a DataSet within the Power BI Service if the data source is Azure Data Lake Store?

Failed to update data source credentials: The credentials provided for the DataLake source are invalid. (Source at https://xxxxxxx.azuredatalakestore.net/.)Hide details
Activity ID: 6ffea8ee-fef7-4da6-989f-fef533ec903a
Request ID: da9cd9d8-875d-f82f-8dae-f02969a716c4

Thanks for any insight you can provide,

Josh
Status code: 400
Time: Wed Jun 14 2017 15:58:10 GMT-0700 (US Mountain Standard Time)
Version: 13.0.1721.113
Cluster URI: https://df-msit-scus-redirect.analysis.windows.net