Refresh error - There is no valid Delta table at this location

Hi, Power BI Service runs in a different execution context than Desktop. It must have direct access to the Delta Lake folder and its metadata (_delta_log). Any failure in path resolution, authentication, or file structure will break it. Ensure you're pointing directly to the folder containing the Delta table, not just a parent folder. I guess something like:

let
    Source = AzureStorage.DataLake("https://xxxx.dfs.core.windows.net/sap/md-silver/my_table/", [HierarchicalNavigation=true]),
    ToDelta = DeltaLake.Table(Source)
in
    ToDelta

Other checks to consider:

- Go to the lake and make sure there is a valid _delta_log folder.

- Validate the azure storage account lakehouse has the hierarchical namespace property enabled.

- Make sure you have edited the credentials at the semantic model settings correctly

- As an alternative you can use AzureLakeStorage function at power query from the azure data lake gen2 connector to navigate the lake until the table and then add a custom step for DeltaLake.Table.

I hope that helps,

Can you please specify networking setup? It looks like a network issue to me. Power BI Service and Power BI Desktop expect to have the same behavior (if networking is configured as it should). 

Thank you ibarrau for the suggestions.

I’ve reviewed them, but unfortunately they didn’t resolve the issue. Any further advice would be greatly appreciated.

Hi pagaczpagacz , in response to your question about the networking setup — we’re using: 

VNet + Private Endpoints on storage account

Hi rhoex ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

Hi rhoex 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you