cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Serverless SQL Cluster giving error with Powerbi

rsamant07
New Contributor III

Power bu Giving this error while accessing delta table using serverless sql endpoint. Error while using path /mnt/xyz/_delta_log/00000000000000000000.checkpoint for resolving path '/xyz/_delta_log/00000000000000000000.checkpoint' within mount at '/mnt/'.

same error in data pane when browsing table details but its working fine with the normal pro cluster. what can be the issue , why is it checking for checkpoint file which is not present for new table but only after 10 updates

3 REPLIES 3

Anonymous
Not applicable

@Rahul Samantโ€‹ :

The error message you're seeing suggests that Power BI is having trouble accessing the checkpoint file for your Delta table when using the serverless SQL endpoint. This file is used by Delta to track changes to the table and ensure consistency, and is typically located in the _delta_log subdirectory of your table's mount point.

The issue can be that the table was created or modified outside of Power BI or if there was an issue with the mount point or Delta configuration.

To troubleshoot this issue, you could try the following steps:

  1. Check that the mount point for your Delta table is correctly configured and accessible from Power BI. You can do this by navigating to the "Data sources" section of your Power BI workspace and verifying that the mount point is listed and connected.
  2. Check that the _delta_log directory and checkpoint file are present in the mount point. You can do this by using the Databricks CLI or the Databricks file browser to navigate to the mount point and inspect the directory structure.
  3. If the _delta_log directory or checkpoint file are missing or inaccessible, you may need to recreate the Delta table or restore it from a backup.
  4. If the issue persists, you may need to investigate further by reviewing the logs and configurations for your Delta table and mount point, or by contacting Databricks support for assistance.

rsamant07
New Contributor III

Dear Suteja,

Thanks for your response, i have checked the above points and the checkpoint file is not present in the _delta_log folder. which seems to be fine as checkpoint is only created after every 10 version and this table is only having 2 versions ,

The problem is not occuring with normal warehouse but only with serverless sql warehouse so it doesn't seem to be the issue with table and files as with normal warehouse it works fine

Anonymous
Not applicable

Hi @Rahul Samantโ€‹ 

Thank you for your question! To assist you better, please take a moment to review the answer and let me know if it best fits your needs.

Please help us select the best solution by clicking on "Select As Best" if it does.

Your feedback will help us ensure that we are providing the best possible service to you.

Thank you!

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group