Forum Discussion
Update dataflow that uses native query
Hi, I have a bunch of dataflows that run a native query from Azure Databricks. The only way I have figured out to update the native query, is to do it in desktop and then copy the m code from th...
Hi CarlBlunck ,
Yes, there is a way to update the native query directly in Azure Databricks without having to go through the advanced editor. You can use the Databricks Power BI Connector to specify native SQL queries as part of setting up your data sources.
Databricks Power BI Connector Native Query | Databricks Blog
Please note that to use the native query feature, the catalog field is required and must be provided, and the native query has to be written to be relative to the provided catalog.
Best regards.
Community Support Team_Caitlyn