move from desktop M query to datamart

[Anonymous]

Hi folks

I have a premium per user licence. I tried to copy paste Desktop Power query table to the Datamart Power Query, but it failed. I did not found an advaced editor either in Datamart Power query. Do you know how to migrate existing (M) Power queries from the desktop to Datamart ? 

[v-xiaosun-msft]

Hi @Anonymous ,

It is impossible to copy and paste M function directly to the Datamart Power Query, because Datamarts provide a no-code visual query designer. And I think you can export data from the table you created with Desktop Power Query first. Then you can choose data source when you create a new datamart.

The formula bar lets you enter your measure. Like Power BI Desktop, the DAX editing experience in datamarts presents a rich editor complete with auto-complete for formulas. 

Please refer to the following document:

Export data from a Power BI visualization - Power BI | Microsoft Learn

Introduction to datamarts - Power BI | Microsoft Learn

Get started with datamarts (preview) - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thank you Xiaosun,

I discovered recently that I could copy M code to the advanced editor in the Power query experience of Datamarts. Therefore we can say anyone can copy and paste Power Query  queries from the Desktop.