~/talk

Introduction to Dataverse

Talkat SQLBits 2023 · 2023-03-14..03-18
links:none on file
slides:none on file

Sets up sandbox and dev environments, creates a Dataverse database, uploads Excel via a dataflow using Power Query, and loads a new TryLife_Sales table with an auto-generated key. Implements a row-level security model using Azure AD groups, business units and a custom security role, adds a calculated TotalSales column (Power Fx preview noted), connects Power BI via DirectQuery preserves dataverse security, builds a canvas mobile app that writes back to Dataverse and successfully submits test records, then exports an unmanaged solution. Backups in sandbox are retained about seven days.

AI-written summary · about

  1. 0:00Introduction and scenario
  2. 2:35Environment setup
  3. 6:14Solution creation
  4. 7:28Importing data
  5. 10:06Dataverse table management
  6. 12:18Security model configuration
  7. 17:53Power BI integration
  8. 21:26Building a canvas app
  9. 28:28Packaging and deployment
  10. 31:46Q&A and backup recovery
  11. 33:22Conclusion and wrap-up
~/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.