Forum Discussion
Error connecting Report Builder to Azure Databricks
Since yesterday, I'm facing issues with connecting to Azure Databricks from Report Builder.
For connecting, I'm using function:
Databricks.Query(Azure_Databricks_Instance, Azure_Databricks_Compute , [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null])
with all parameters set correctly and never changed since weeks.
Suddenly, the following error began to occurr:
Do you have any idea what could be the reason for this error?
Thank you in advance for any help.
Hello Yang,
no recent change was made and all the parameters were correctly set . After further investigation, we finally succeeded in solving the issue by replacing Databricks.Query function (that suddenly stopped working on paginated reports / report builder, but luckily not in Power BI) with Value.NativeQuery function.
Do you know if something changed in the integration of Databricks.Query in Report Builder recently?
Thank you
Francesca
3 Replies
Hi fbottazzoli ,
The error message indicates a problem with the parameter.
Here are some of my suggestions:
- Make sure that all parameters in the Databricks.Query function are set correctly. If any of them are set to null, try providing explicit values.
- DefaultTypeParameter indicates that the default value of the parameter is not recognized. Check if the parameter has been changed recently.
- Since the error message is in Italian, make sure that the system's language or locale settings match the expected configuration for Azure Databricks.
If these steps do not resolve the issue, can you share more details about your recent changes? This will help resolve your issue.
Best Regards,
Yang
Community Support TeamIf 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!Hello Yang,
no recent change was made and all the parameters were correctly set . After further investigation, we finally succeeded in solving the issue by replacing Databricks.Query function (that suddenly stopped working on paginated reports / report builder, but luckily not in Power BI) with Value.NativeQuery function.
Do you know if something changed in the integration of Databricks.Query in Report Builder recently?
Thank you
Francesca
Hi fbottazzoli ,
Based on the latest updates and release notes for Azure Databricks and related integrations, there doesn't appear to be any explicit documentation about the function changes in Report Builder. I would recommend keeping a close eye on the URL below to see if there are any announcements or fixes:
Databricks SQL release notes 2025 | Databricks Documentation
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
Best Regards,
Yang
Community Support TeamIf 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!
