topic Re: Serverless SQL Cluster giving error with Powerbi in Data Engineering

Serverless SQL Cluster giving error with Powerbi

rsamant07 — Tue, 28 Feb 2023 10:53:32 GMT

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

Re: Serverless SQL Cluster giving error with Powerbi

Anonymous — Thu, 09 Mar 2023 03:03:05 GMT

@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:

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.
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.
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.
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.

Re: Serverless SQL Cluster giving error with Powerbi

Anonymous — Mon, 13 Mar 2023 04:40:33 GMT

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!

Re: Serverless SQL Cluster giving error with Powerbi

rsamant07 — Mon, 13 Mar 2023 08:11:19 GMT

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