Forum Discussion
Refresh error - There is no valid Delta table at this location
Hi rhoex ,
Please verify if this limitations is causing the error you are experiencing
Microsoft doesn't support dataflow or semantic model refresh using OAuth2 authentication when the Azure Data Lake Storage Gen2 (ADLS) account is in a different tenant. This limitation only applies to ADLS when the authentication method is OAuth2, that is, when you attempt to connect to a cross-tenant ADLS using an Microsoft Entra ID account. In this case, we recommend that you use a different authentication method that isn't OAuth2/Microsoft Entra ID, such as the Key authentication method.
Another point is as you have mentioned you are using VNet + Private Endpoints on storage account so please configure a Vnet gateway and re check.
What is a virtual network (VNet) data gateway | Microsoft LearnOverview of virtual network (VNet), private links, and Power BI | Microsoft Learn
Create virtual network (VNet) data gateways | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi rhoex ,
This issue happens when the data source you used, within Power BI Desktop, isn't supported for refresh. You need to find the data source that you're using and compare that against the list of supported data sources at
Data refresh in Power BI - Power BI | Microsoft Learn
Data refresh in the Power BI service will fail when the source column or table is renamed or removed. It fails because the Power BI service doesn't also include a schema refresh. To correct this error, a schema refresh needs to happen in Power BI Desktop and the semantic model needs to be republished to the service.
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi v-nmadadi-msft, thank you for your response.
I reviewed the link you shared and through additional page it can be concluded that Azure Data Lake Storage Gen2 with Delta Lake is supported.
Reminding that Power BI service doesn't include a schema refresh is useful but not in my case. I testing refresh in Servce, without changing anything since publishing this from from PowerBI Desktop.
Thank you,
rhoex
Hi rhoex ,
Please verify if this limitations is causing the error you are experiencing
Microsoft doesn't support dataflow or semantic model refresh using OAuth2 authentication when the Azure Data Lake Storage Gen2 (ADLS) account is in a different tenant. This limitation only applies to ADLS when the authentication method is OAuth2, that is, when you attempt to connect to a cross-tenant ADLS using an Microsoft Entra ID account. In this case, we recommend that you use a different authentication method that isn't OAuth2/Microsoft Entra ID, such as the Key authentication method.
Another point is as you have mentioned you are using VNet + Private Endpoints on storage account so please configure a Vnet gateway and re check.
What is a virtual network (VNet) data gateway | Microsoft LearnOverview of virtual network (VNet), private links, and Power BI | Microsoft Learn
Create virtual network (VNet) data gateways | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you