Forum Discussion
Invalid Credentials Error in Power-BI Service Despite Successful Connection in PBI Desktop. (ADLS)
I went to check this again.
Please try the following programs:
Do Power Query Online and Azure Storage have the same region? If yes, please refer to
Azure Data Lake Storage Gen2 - Power Query | Microsoft Learn
You need to use either an On-premises data gateway or a Virtual Network (VNet) data gateway to access Azure Storage from Power Query Online in the same region.
Do Power Query Online and Azure Storage have different regions? If yes, you need to add the IP addresses of the Power Query Online region to the Azure Storage Firewall in the 'Networking' settings.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I've noticed on the documentation you've shared that it says the following relating to ADLS Gen2 connectors:
LimitationsSubfolder or file not supported in Power Query OnlineCurrently, in Power Query Online, the Azure Data Lake Storage Gen2 connector only supports paths with container, and not subfolder or file. For example, https://<accountname>.dfs.core.windows.net/<container> will work, while https://<accountname>.dfs.core.windows.net/<container>/<filename> or https://<accountname>.dfs.core.windows.net/<container>/<subfolder> will fail. |
Does this mean that if I have multiple parquet files stored within a subfolder of this directory, that this might explain the refresh error? If so, is there a way around this?
If feasible, consider reconfiguring the datastore by moving the necessary files to the root of the container.
For more complex scenarios or when working with large amounts of data across multiple subfolders, consider using Azure Data Factory.
Regards,
Nono Chen