Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
I am currently working on Fabric Lakehouse and Data Pipeline. I did refresh semantic power bi models using data pipeline in Fabric, which before the process there was other activities, one of which was copy-activity and drop-create table using the notebook. But I have experienced an error like this for 3 days at the refresh dashboard stage.
Data source error: DataSource.Error: Microsoft SQL: Failed to complete the command because the underlying location does not exist. Underlying data description: table 'dbo. ......
So my table is unreadable, but when I refresh my SQL analytics endpoint manually then re- run my data pipeline to refresh semantic model again, it is successful because the schema of the table is read. Its look like the SQL analytics endpoint didn't refresh automatically. Please help.
Solved! Go to Solution.
There can be sync delays between Lakehouse and SQL Analytics Endpoint:
https://www.reddit.com/r/MicrosoftFabric/comments/1ercfha/sql_analytics_endpoint_performance/
Here are some recommendations and considerations:
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance
I am hoping there will come some improvements in this area.
Hi @ashafaa ,
Similar threads:
Solved: SQL Endpoint error: Failed to complete the command... - Microsoft Fabric Community
SQL Analytics Endpoint performance : r/MicrosoftFabric (reddit.com)
You can submit an idea to the product team to optimize the sync performance from Lakehouse to SQL Analytics Endpoint to keep it within a manageable timeframe.
Welcome to Microsoft Fabric Ideas
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
There can be sync delays between Lakehouse and SQL Analytics Endpoint:
https://www.reddit.com/r/MicrosoftFabric/comments/1ercfha/sql_analytics_endpoint_performance/
Here are some recommendations and considerations:
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance
I am hoping there will come some improvements in this area.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
55 | |
27 | |
18 | |
10 | |
4 |
User | Count |
---|---|
71 | |
67 | |
20 | |
8 | |
6 |