~/talk

Power BI Meets Programmability – TOM, XMLA, and C#

on YouTube 47m
Talkat SQLBits 2023 · 2023-03-14..03-18· [data-visualization]

speaker

name:Kristyna Hughes
links:none on file

resources

video:https://youtu.be/J9krvt5HR24
slides:none on file

summary

Demonstrates programmatic edits to Power BI models using C# + XMLA endpoint and TOM (Tabular Object Model): creates data and calculated columns, updates DAX measures (example flips "Hello World" to "Hello happy coders"), reorders and adds hierarchy levels, and adds culture translations that overwrite display names. Requires Premium/Premium Per User, shows full-refresh then save order is vital, forces browser refresh for visuals, and notes once written via XMLA the PBIX download is no longer available. translations overwrite

AI-written summary · about

chapters (8)

  1. 0:00Introduction
  2. 1:11Enterprise data strategies
  3. 2:37Core concepts and setup
  4. 4:30Initial model exploration
  5. 17:46Adding columns and measures
  6. 24:02DAX integration
  7. 30:11Managing hierarchies
  8. 41:14Translations and conclusion

related talks

~/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.