If you’re looking for Excel functions in Power BI, you will recognize that much more of them have been transformed to native DAX functions than to native M functions in (…) Read more
Posts Tagged ‘Power Query’
Power BI Cleaner Gen2 is here
Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more
Fix error “..prod.powerquery.microsoft.com refused to connect” in Power BI dataflows
Today I could not edit any dataflows for a client and was constantly getting “… prod.powerquery.microsoft.com refused to connect”: Twitterverse to the rescue After a couple of unsuccessful trials (…) Read more
Power BI Cleaner now fully covers Calculation Groups
Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more
Extract only letters from a mixed string in Power Query and Power BI
This is a quick method about extracting only letters from a string. It is part of the Week2 “Preppin’ data” challenge. Task for extracting letters from a string Image you (…) Read more
Clean up or harmonize mis- or differently spelled category data with Power Query
A typical problem with data that has been created by manual entries is that category values are often misspelled or missed. So in this article I’m showing a very powerful (…) Read more