New Features - COMMON DATA SERVICE, SQL AND POWER BI !!! | #PowerPlatformTV 021

preview_player
Показать описание
Welcome to POWER PLATFORM TV!
SUBSCRIBE to keep up to date on the Microsoft Power Platform, Power BI, Power Apps, Power Automate, Dynamics 365, and more.

In this video, we look at the new preview features to access the Common Data Service directly from SQL Server Management Studio and access the CDS using Direct Query with Power BI. These features include the security model and it makes it easy to get option set and lookup labels.

Channel Intro: 0:00
Common Data Service, SQL, Power BI: 0:11
Check Version for Preview: 0:54
Enable Preview in Admin Center: 2:51
SQL Server Management Studio: 4:25
Security, Option Sets, Lookups: 13:40
Create Power BI report: 23:19
Publish to Power BI service: 31:03
Configure in Service and Share report: 34:12
Embed report in Dynamics 365 / Power App: 37:32

If you enjoyed the video, please LIKE and SUBSCRIBE!

And PLEASE follow me on:

Thanks!
Рекомендации по теме
Комментарии
Автор

Thanks for this Carl, very interesting, I use data export service data a fair bit. TDS seems to be disabled by Microsoft at the moment so I can't try it, I was wondering how the schema compares to data export service, are field names and data types the same? Thanks

theagiledatadevltd
Автор

Thanks for this. Will i be able to obtain flow and PowerApp information. i.e. list of all flows and powerapps?

bedsup
Автор

Such an underrated YouTuber! Should have at least 100k subs!

mowgaz
Автор

I'm interested in getting Daily Active Users (DAU) via a SQL query and reading directly SSMS common data service connection.

marcelacardenas
Автор

Thanks for sharing. Very helpful. Do you know if we will be able to use this in SSRS reports.

saileshshah
Автор

This is amazing! Do you know when these features will go live from preview? Cheers

StreetCertifiedRecords
Автор

It would be huge from the reporting aspect.

nancydsouza
Автор

As always, lot's super useful information

igor
Автор

👌👌👌👌👌Very good explanation D365 master @carl de souza

joyfullearning
Автор

Sir I'm naushad. I request u to make wep api in . Netcore

naushadali