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 ‘Dataflows’
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
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
Convert DateTime to ISO 8601 date and time strings in Power Query
Often, when querying APIs it is required to enter date and time filters in ISO 8601 format . Today I show a quick way to convert DateTime to ISO 8601 string, (…) Read more
Create a load history or stage in CDS instead of incremental load in Power BI
If you’ve been following my blog for a while, you might have noticed my interest in incremental load workarounds. It took some time before we saw the native functionality for (…) Read more