Business Intelligence, Data Governance, Mental Health, Diversity, Martial Arts, and Heavy Metal.
I don’t hear this question as often as I used to[1], but I still hear it: What’s the difference between dataflows in Power BI and Data Flows in Azure Data Factory? I’ve already written extensively on the Power BI side of things, and now the awesome Merrill Aldrich from BlueGranite has published an excellent overview …
Power BI datamarts are like dataflows with benefits. In case you missed the announcements this week from Microsoft’s Build conference, datamarts are a new major new capability coming to Power BI that are now available in public preview. There are also preview docs available, but the best datamarts content I’ve seen so far is this …
As you may have noticed, life is complicated and keeps getting in the way of my plans to be a more active blogger and YouTuber[1]. I haven’t released a new dataflows video of my own in far too long[2], but my teammate Kasper is helping out by doing the hard work for me: Last week …
Life and work have been getting the best of me this month, and I haven’t found the time[1] to keep up on blogging and video now that my series on building a data culture has wrapped up. I’ve been watching the dataflows and Power Query teams releasing all sorts of exciting new capabilities, and realizing …
A lot of the questions I get about dataflows in Power BI boil down to the simplest[1] question: “Why dataflows?” On Saturday November 7 I joined MVP Reid Havens for a YouTube live stream where we looked at this question and a bunch of other awesome dataflow questions from the 60+ folks who joined us. …
Continue reading “Why dataflows?” webcast recording now online
Last week I saw this scenario cross my screen: I’m trying to use dataflows with DirectQuery. I’ve pushed all the data into a dataflow, around 1.5 billion rows, and am trying to DirectQuery all the data. Performance is quite slow. There’s a lot here to unpack, but I want to start with this[1]: As covered …
This morning I presented a new webinar for the Istanbul Power BI user group, covering one of my favorite subjects: common patterns for successfully using and adopting dataflows in Power BI. This session represents an intersection of my data culture series in that it presents lessons learned from successful enterprise customers, and my dataflows series …
Continue reading Session resources: Patterns for adopting dataflows in Power BI
tl;dr: If you want to refresh a dataflow without refreshing any downstream dataflows that depend on it, just clear the “Enable Load” setting from any linked entities that reference it. This will remove the dependencies that the Power BI service looks for, without breaking any of the downstream dataflow logic. Win! At the end of …
I’ve been seeing more questions lately about the dataflows enhanced compute engine in Power BI. Although I published a video overview and although there is feature coverage in the Power BI documentation, there are a few questions that I haven’t seen readily answered online. A lot of these questions can be phrased as “what happens …
Continue reading Dataflows enhanced compute engine – will it fold?
If you’ve come to this blog to learn more about Power BI dataflows, here’s a good place to start. First of all, here are posts that consolidate and link to dataflows resources available elsewhere online. Start here: Dataflows in Power BI: Resources More Resources: Power BI Dataflows and Azure Data Power BI Dataflows FAQ Power …
Founder & CEO Of Data Relish, Global keynote speaker and influencer and trusted advisor in AI, Data Science and Business Intelligence
Blogging about everything related to Data and AI based on Microsoft technology
Swimming through the Sea of SQL
The blog of Raphael Branger
I think I have some AAA batteries in here
A Power BI Creator Blog
A data science blog by Caitlin Hudon
Microsoft Power BI, Analysis Services, DAX, M, MDX, Power Query and Power Pivot
Things that matter
Business Intelligence, Data Governance, Mental Health, Diversity, Martial Arts, and Heavy Metal.
SQL/Analytics/AI/Speaker/Diversity & Inclusion
Business Intelligence, Data Governance, Mental Health, Diversity, Martial Arts, and Heavy Metal.
BI Polar 