SQL on Dataverse in Power BI
Write SQL to query data in Dataverse to use in a Power BI report. All the code used in the video can be found on the supporting blog post at
https://hatfullofdata.blog/using-sql-...
Table of Contents
00:00 Introduction
00:15 Get Database path
00:31 SQL Server Management Studio
00:47 Connect Dataverse
02:01 Write SQL to fetch data
04:01 Use SQL in Power BI
06:07 Permission to run SQL
06:59 Select Storage Mode
08:29 Report in Workspace