I didnt know that this language existed until messing with Power query editor for my job. Fast forward a week, and I'm writing scripts in this random language built directly into power query which, in itself, is built into excel... So overengineered. I love it
Awesome :) Love from India. I was looking a comprehensive tutorial on M language, it appears my search ends here. I will go through the entire library, and tell how it goes.
Really good overview, thanks a lot. What I'd really like to do is use this engine to send a multi-statement query to SQL server from VBA. With the macro editor I can see that this uses mashup. Using ADO I cannot send a declare statement, and apparently mashup can. I'd love to understand how to manipulate the output as an array, if it is one.
I encounter a lot of errors when I am using power query and I don't know how to fix,is that possible for you to have one traing on how use M language to fix errors
Hey thanks for this breakdown. I was wondering, I am using the M language in a pollingexpression for a customized refresh policy using TMSL script in MSS (microsoft sql server management studio) . This instance in MSS is a powerbi xmla endpoint. Now what I was wondering, I will need to compare the amount of rows or such to see if there are changes between the azure sql database and the powerbi dataset which is linked in MSS. The refresh itself will be triggered on API call with logic apps so this is not an issue. The issue is to flag the partitions to do a full refresh on the partition that has more rows or is not conisistent with the powerbi dataset. Is this possible? thank you in advance!
Thanks for this brilliant series on M Language. Currently in Aug 2022, this playlist is #1 on this topic. No competitor.
I didnt know that this language existed until messing with Power query editor for my job. Fast forward a week, and I'm writing scripts in this random language built directly into power query which, in itself, is built into excel... So overengineered. I love it
Awesome :) Love from India. I was looking a comprehensive tutorial on M language, it appears my search ends here. I will go through the entire library, and tell how it goes.
Thank you so much!
Really good overview, thanks a lot. What I'd really like to do is use this engine to send a multi-statement query to SQL server from VBA. With the macro editor I can see that this uses mashup. Using ADO I cannot send a declare statement, and apparently mashup can. I'd love to understand how to manipulate the output as an array, if it is one.
You're a badass. Good work.
I encounter a lot of errors when I am using power query and I don't know how to fix,is that possible for you to have one traing on how use M language to fix errors
Hey thanks for this breakdown. I was wondering, I am using the M language in a pollingexpression for a customized refresh policy using TMSL script in MSS (microsoft sql server management studio) . This instance in MSS is a powerbi xmla endpoint. Now what I was wondering, I will need to compare the amount of rows or such to see if there are changes between the azure sql database and the powerbi dataset which is linked in MSS. The refresh itself will be triggered on API call with logic apps so this is not an issue. The issue is to flag the partitions to do a full refresh on the partition that has more rows or is not conisistent with the powerbi dataset. Is this possible? thank you in advance!
How can I become expert in M language to manipulate data, fuzzy logic, etc when I have office 16 excel