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
Guest Post: Using List.Accumulate for Input/Output Genealogy
Foreword from Imke: Pat Mahoney is a very active fellow super user in the Power BI community and has a very strong interest in all things Power Query. He also (…) Read more
Workaround to connect to Power BI dataflows from Power Query in Excel
Currently, we cannot connect to Power BI dataflows from Excel Power Query. And as we also cannot use custom connectors in there, we need a different alternative. I’m going to (…) Read more
Exception reporting and management for missing fuzzy matches in Power BI
In a previous article I have described how to use Fuzzy merge to match misspelled data to valid categories. With the sample data at hand, all values could be matched (…) Read more