~/talk

Go With The (data)Flow

Talkat SQLBits 2023 · 2023-03-14..03-18· [data-engineering]
links:none on file
slides:none on file

Overview of Power BI Dataflows as cloud staging in Power BI Service that use Power Query (M) to cleanse, merge and share entities; dataflows support scheduled refresh, reusable entities for multiple datasets, and JSON export/import (via an external tool) to copy environments. Premium unlocks compute engine, DirectQuery/linked entities, incremental refresh and ML. Concrete gotchas: SharePoint loads can be faster via dataflows, refresh history errors download as CSV, and orchestration requires schedule dataflows before datasets to keep reports current.

AI-written summary · about

  1. 0:00Introduction and overview
  2. 3:21What are Power BI data flows
  3. 7:19Why data flows matter
  4. 11:43Demo: Exploring data flows
  5. 16:45Using data flows in Power BI Desktop
  6. 23:19Moving data flows between workspaces
  7. 27:52Creating data flows from scratch
  8. 31:32Advanced data flow creation tips
  9. 37:03Lineage and data flow connections
  10. 40:13Multiple data sets from one flow
  11. 45:16Scheduling refreshes correctly
  12. 47:26Summary and Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.