I have resolved the issue, had to whitelist the Azure IP's for my region in the ADLS.
https://www.microsoft.com/en-us/download/details.aspx?id=41653&751be11f-ede8-5a0c-058c-2ee190a24fa6=True
Can't connect to our ADLS gen2 in Powerbi Online (scheduled refresh)
Hi all,
We have recently set up a ADLS gen 2 and we want to update our reports automatically. In the powerBI desktop version everything works, but online I get the following error:
Failed to update data source credentials: The credentials provided for the AzureDataLakeStorage source are invalid.
I have given reader/owner role access in the ADLS for Power BI Premium, Power BI Service and Power Query Online.
Does anybody know how to solve this problem?
3 answers
Sort by: Most helpful
-
Joris 6 Reputation points
2020-07-15T16:06:35.267+00:00 -
Girijesh Pandey 1 Reputation point
2020-07-29T15:20:33.347+00:00 Dear @Joris-3620 ,
I had also experienced similar issues and it resolved by allowing Azure IP's for from the region ADLS is located.
Whitelist the Azure IP's is a key to solve this sort of error.Pls let us know if you are facing any other challenge.
Regards,
Girijesh -
Elizabeth Fohl 1 Reputation point Microsoft Employee
2020-10-01T17:08:46.117+00:00 I am running into the same. There are about 150+ IP addresses for my region. Is there a recommended way to bulk load these IP addresses, or is it recommended to manually maintain?