~/talk

Building and using Organizational data types

on YouTube 20m
Talkat SQLBits 2023 · 2023-03-14..03-18· [data-visualization, developer-experience]

speaker

name:Lars Andersen
links:none on file

resources

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

summary

Shows how to create an organizational data type as a Power BI featured table (must be 100% import) with a row label and unique key, publish it, and consume it in Excel online and desktop. Sensitivity labels set in Power BI inherit into Excel. Images require the Image URL data category. Pivot tables do not work; tables only. Demo includes live lookup, expanding attributes, and a working writeback example using an Office Script that calls an Azure Function to update SQL.

AI-written summary · about

chapters (5)

  1. 0:00Introduction to data types
  2. 0:48Excel data type categories
  3. 2:55Building organizational types
  4. 5:53Consuming data in Excel
  5. 13:29Advanced use cases and tips

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.