Webcast: Patterns for adopting dataflows in Power BI

I haven’t been posting a lot about dataflows in recent months, but that doesn’t mean I love them any less. On Wednesday September 23rd, I’ll be sharing some of that love via a free webcast hosted by the Istanbul Power BI user group[1]. You can sign up here. In this webcast I’ll be presenting practices …

Continue reading Webcast: Patterns for adopting dataflows in Power BI

Power BI dataflows PowerShell scripts on GitHub

Last week I shared a post highlighting a common pattern for making API data available through dataflows in Power BI, and included a few diagrams to show how a customer was implementing this pattern. In the post I mentioned that I was simplifying things a bunch to only focus on the core pattern. One of …

Continue reading Power BI dataflows PowerShell scripts on GitHub

Dataflows and API data sources

These days more and more data lives behind an API, rather than in a more traditional data source like databases or files. These APIs are often designed and optimized for small, chatty[1] interactions that don’t lend themselves well to use as a source for business intelligence. These APIs are often slower[3] than a database, which …

Continue reading Dataflows and API data sources

Weekend reading: New dataflows docs

In case you didn’t have any plans for the weekend, the Power Query team has released a treasure trove of new documentation for dataflows in Power BI and Power Apps. You can find the new docs here: https://docs.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365 There are over 20 articles in this new resource, and the content they contain answers many of …

Continue reading Weekend reading: New dataflows docs

Power BIte: Power Platform dataflows

INTERIOR: pan over cubicles of happy, productive office workers CLOSE-UP: office worker at desk NARRATOR: Is that Susie I see, giving Power Platform dataflows a try? SUSIE: That’s right! With dataflows I can have all of the data I need, right where I need it!! NARRATOR: Dataflows. They’re not just for Power BI anymore. OK, …

Continue reading Power BIte: Power Platform dataflows

Power BIte: Dataflows enhanced compute engine

The enhanced compute engine in Power BI dataflows has been in preview since June. It’s not really new, and I’ve posted about it before. But I still keep hearing questions about it, so I thought it might make sense to record a video[1]. This video. I won’t go into too much more depth here – …

Continue reading Power BIte: Dataflows enhanced compute engine

Power BIte: Turning datasets into dataflows

At this point I’ve said “Power BI dataflows enable reuse” enough times that I feel like a broken record[1]. What does this phrase actually mean, and how can you take advantage of dataflows to enable reuse in your Power BI applications? This Power BIte video is a bit longer than its predecessors, and part of …

Continue reading Power BIte: Turning datasets into dataflows

Power BIte: Creating dataflows by attaching external CDM folders

This week’s Power BIte is the fourth and final entry in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by attaching an external CDM folder, the dataflow will have the following characteristics: Attribute Value Data ingress path Ingress via …

Continue reading Power BIte: Creating dataflows by attaching external CDM folders

Power BIte: Creating dataflows by importing model.json

This week’s Power BIte is the third in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by importing a model.json file previously exported from Power BI, the dataflow will have the following characteristics: Attribute Value Data ingress path Ingress via …

Continue reading Power BIte: Creating dataflows by importing model.json