More than Excel BI
Update 4 June 2019: unfortunately, the function was not meant to be published. The function is part of a certified connector and is now hidden.
The May 2019 release of Power BI Desktop includes a new M function: Text.ReplaceAll (not documented on Microsoft Docs as of 18 May 2019). This function simplifies multiple word replacements that previously had to be done by using custom functions. Continue reading “New M function: Text.ReplaceAll”
Recently I’ve been migrating quite a few M queries from .pbix files to dataflows. In this blog post, I’m sharing a few things I learned in the process. Continue reading “Power BI dataflows considerations”
Remember my post about DAX formula bar keyboard shortcuts in Power BI Desktop? Turns out, there are also lots of keyboard shortcuts in Advanced Editor inside Power Query Editor in Power BI, with many being the same as in DAX formula bar! Continue reading “Power Query Advanced Editor keyboard shortcuts”
The November 2017 release of Power BI Desktop contains a new M function: Function.From. Here is the function’s description from the official documentation: Continue reading “New M function: Function.From”