Power Query Formula Language - Scheduled Refresh ?

[revansh]

Hi All,

We have created a powerbi dataset using below steps and added couple of visuals on the report and exported to powerbi.com.

/*
The exported Power Query Formula Language (M Language ) can be used with Power Query in Excel
and Power BI Desktop.
For Power BI Desktop follow the instructions below:
1) Download Power BI Desktop from https://powerbi.microsoft.com/desktop/
2) In Power BI Desktop select: 'Get Data' -> 'Blank Query'->'Advanced Query Editor'
3) Paste the M Language script into the Advanced Query Editor and select 'Done'
*/

QUESTION:

trying to setup auto refresh for this scenario.

Could you provide some inputs on scheduled refresh for M LAnguage.

Thanks

[v-yulgu-msft · Accepted solution]

Hi @revansh,

First, scheduled refresh is not yet supported in Power BI desktop. Additionally, it is not available to make Power Query automatically update either in desktop or in service. We have to manually change it in desktop in Advanced Editor.

Regards,

Yuliana Gu