Forum Discussion
Microsoft.Data.Mashup.ValueError.Message Referenced external data source (null) not found. Error...
Hi adrianczerski - The error you're experiencing with your Power BI model when reading from Azure Synapse Serverless SQL Pool, specifically the "Referenced external data source "(null)" not found. Error reading external metadata," is not uncommon with setups involving Synapse, Azure Data Lake, and external data sources. This type of intermittent issue can be due to several factors, including temporary service issues, metadata syncing issues, or limitations with Synapse Serverless SQL Pools.
Since Synapse Serverless SQL Pools work on top of Azure Data Lake storage, sometimes there are delays or connectivity issues when retrieving external metadata. This may cause intermittent failures, especially if the metadata sync between Synapse and Data Lake is delayed.
As a workaround, consider implementing a retry logic in Power BI or Power Automate if this refresh is part of an automated process. A simple retry can sometimes bypass intermittent connectivity or availability issues.
Hi adrianczerski - The error you're experiencing with your Power BI model when reading from Azure Synapse Serverless SQL Pool, specifically the "Referenced external data source "(null)" not found. Error reading external metadata," is not uncommon with setups involving Synapse, Azure Data Lake, and external data sources. This type of intermittent issue can be due to several factors, including temporary service issues, metadata syncing issues, or limitations with Synapse Serverless SQL Pools.
Since Synapse Serverless SQL Pools work on top of Azure Data Lake storage, sometimes there are delays or connectivity issues when retrieving external metadata. This may cause intermittent failures, especially if the metadata sync between Synapse and Data Lake is delayed.
As a workaround, consider implementing a retry logic in Power BI or Power Automate if this refresh is part of an automated process. A simple retry can sometimes bypass intermittent connectivity or availability issues.