Important: This post was written and published in 2019, and the content below may no longer represent the current capabilities of Power BI. Please consider this post to be an historical record and not a technical resource. All content on this site is the personal output of the author and not an official resource from Microsoft.
If you head on over to the official Power BI blog today you’ll see this announcement, and if you’re like me there will be a few things that immediately jump out at you:
- That’s almost two features per day
- Dataflows should have a lower-case D
- Miguel’s profile picture is even older than Matthew’s profile picture
All snark aside, Miguel and the whole dataflows team have been awfully busy, and it’s great to see their work available to Power BI authors. I won’t attempt to repeat what’s in the announcement, but I will highlight the new capabilities that have me most excited:
- Support for data profiling in Power Query Online – we’ve had this in Power BI Desktop for a while, but it’s just as important for dataflows as it is for datasets.
- Better support for files and folders – a lot of the data I play with these days is in folders full of text files, and Power Query Online hasn’t had the best experience for working with this type of data.
- Better support for query parameters – there are lots of scenarios where having parameterized queries makes working with dataflows easier, and now Power Query Online makes it easier to work with query parameters.
Do yourself a favor and check out the whole list. Odds are there’s something you’ve been waiting for that will excite you as much as these new capabilities excite me.
And I can’t wait to hear what they are…
 No, I don’t believe that’s possible either, but it is nice to see that you’ve been paying attention.
 Very little of my actual work involves data prep these days, so I need to find data to play with to avoid getting too bored.
 Like this one.
4 thoughts on “Power BI dataflows November updates”
Wow! An impressive release. Aligning the features with desktop (and it looks like maybe even adding more…?) is a big win for the powerquery online platform. Thank you!
Any thanks go to Miguel and the PQO team – I’m just the messenger…
Best feature for us = Being able to Merge/Append two dataflows in Power BI desktop, publish to the service, and have it successfully refresh. This was not working before and we are thrilled to see it now in place.
The ODBC is biggest for me. Let’s me use IBM I aka iSeries aka AS400 just like in Excel.