Formula.Firewall issues can hit you when designing your queries or even “out of the blue” when suddenly refreshes in the service are failing due to changes in the query evaluation. (…) Read more
Posts in Category ‘Dataflow’
Transforming multiple columns at once with reference to existing column in Power Query
In this article I’m going to present a method about transforming multiple columns at once in a fast way. This method also allows you to reference columns that exist in (…) 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