Forum Discussion

stevenmcginnis's avatar
stevenmcginnis
Icon for Helper I rankHelper I
2 years ago

Invalid Credentials Error in Power-BI Service Despite Successful Connection in PBI Desktop. (ADLS)

I have a Power BI report that pulls data from Azure Data Lake Storage (ADLS). I can load and refresh the data smoothly using Power BI Desktop, but I encounter an issue when publishing the report to t...
General Comment
Need Help
Tutorial Requests
stevenmcginnis's avatar
stevenmcginnis
Icon for Helper I rankHelper I
2 years ago

I've noticed on the documentation you've shared that it says the following relating to ADLS Gen2 connectors:

 

Limitations

Subfolder or file not supported in Power Query Online

Currently, 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?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi stevenmcginnis 

 

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