Edit 23rd August 2021: This article is outdated, please read the updated version here: Power BI Cleaner Gen2 now covers Analysis Services Models as well Today I’m very excited to (…) Read more
Posts in Category ‘Power BI’
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 27th June 2021: There is a complete new version of this tool that has all the bugfixes and enhancements here: https://wp.me/p6lgsG-2pi You can now download a new version of (…) 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
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
Your Oracle data import in Power BI and Power Query is slow?
If you’re using the native Oracle connector in Power Query, you will probably experience a very slow import performance. Thanks to Tristan Malherbe for recommending to use the OleDB-connector in (…) Read more