Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
10 years ago

M query in live connection

hi,

 

how could i know which functions can i use in M on live connection?

in some data source, 'advanced editor' is disabled, in ADW it enables but 'table.addcolumn' doesnt work, filter rows do work...

 

how can i know?

 

thanks!

Need Help

2 Replies

  • achinm45's avatar
    achinm45
    Advocate IV
    10 years ago

    Hi MP_123

    In general, anything which tries to modify table structure may not work.

    Those functions which can filter the data, modify the data at ADW can work.

     

    Achin

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    10 years ago

    MP_123

     

    Are you sure that you can filter rows in a live connection?

     

    In Power BI Desktop, all of the query and modeling features in Power BI Desktop should be disabled when exploring live data, so even filtering rows should not work.

     

    Regards,