Update dataflow that uses native query

[CarlBlunck]

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 the advanced editor and paste it into the dataflow's table (via advanced editor).

Which is painful.  Is there a way to update the native query directly in the dataflow without having to go through the advanced editor?

Cheers

Carl

[mark_timmis]

Hi @CarlBlunck

Did you find a way to do this directly in the online dataflow? I'm facing the same challenge.
Thanks
BR Mark

[CarlBlunck]

Hi @Anonymous 

I need to be able to do this in a powerbi online dataflow, not in powerbi desktop.

Thanks

Carl

[Anonymous]

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