Microsoft Dataverse Overview

In this video, we will talk all about Microsoft Dataverse and cover the following topics:
What is Microsoft Dataverse?
What is the backend architecture?
Relational Data Structure.
Dataverse Tables, Views, Forms, Business Rules & more.
Demo of Dataverse & Azure Synapse Link.
Joining Reza Dorrani & Daniel Christian aka R&D is Ryan Jones (Microsoft - Partner Director of Program Management). Ryan will provide an Overview of Microsoft Dataverse with live demos.
RnD Show Playlist 🔗 • The R&D Show Season 1
📢 Q&A Rules:
👉 We will open the floor for live Q/A at end of session.
👉 Put "Q:" in front of your comments and post your question.
👉 Please do not re-post your questions.
👉 We will try to answer as many questions as possible live.
#Dataverse #Microsoft #PowerPlatform #PowerApps #RnD_Show

Пікірлер: 90

  • @RezaDorrani
    @RezaDorrani2 жыл бұрын

    Presentation Deck Link - rezadorrani.com/index.php/2021/09/11/introduction-to-microsoft-dataverse/

  • @rachitgarg1016

    @rachitgarg1016

    2 жыл бұрын

    Thanks for sharing the deck. This was one of the best session on Introduction to Dataverse.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@rachitgarg1016 Thanks Rachit

  • @karldonaubauer6898

    @karldonaubauer6898

    2 жыл бұрын

    Thanks for sharing! The resolution is much better with the original than with stealing his structural slides via screenshot as we all do for years when it comes to Dataverse/CDS. ;-)

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@karldonaubauer6898 Very kind of Ryan to share the deck.

  • @karldonaubauer6898

    @karldonaubauer6898

    2 жыл бұрын

    @@RezaDorrani Yes! I'm using some of Ryan's slides at a conference soon. As a thank you, you can tell him at the next opportunity: He was unhappy with his slides #2-4 because he couldn't think of anything for Virtual Agent that starts with "A". I'll use "Answer" for my presentation as this is the major chat bot purpose.

  • @antoniokimble5286
    @antoniokimble52862 жыл бұрын

    Reza, you look like you've been working hard there pal. I'm a little scruffy myself but I like calling it the "Workin' Man's Look". I'm trying to put in this work, but you sir, are definitely putting in that work. Shoutout to the collaboration with Daniel as well!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks Antonio. Yes, I am playing a lot of roles in life currently. I will be back to my space in 3 weeks time.

  • @oluwatobiyusuf
    @oluwatobiyusuf2 жыл бұрын

    Thanks you Reza, Daniel and Ryan. I gained a lot from this session. Most importantly, I can now advise clients on the best data storage to use depending on the work case.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad to hear that! Thank you for watching.

  • @marioroberto1841
    @marioroberto18412 жыл бұрын

    Salve Reza. Parabéns pelo maravilhoso trabalho e pelos vídeos com conteúdos preciosos. Agradeço também a oportunidade de ver essas feras todas em uma live. Muito obrigado. Grande abraço a Daniel e Ryan também. Parabéns a todos.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thank You!!!

  • @jimfitch
    @jimfitch2 жыл бұрын

    I finally watched this presentation. Awesome. Ryan Jones is a cool guy ... just like his hosts. Thanks for putting this together. Very informative.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Our pleasure! Ryan is the best!

  • @RPG_ash
    @RPG_ash2 жыл бұрын

    Didn't think I'd watch all of this but found it really interesting as I've just started to learn about Dataverse 👍🏻

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks for watching.

  • @365g
    @365g2 жыл бұрын

    Hi Guys - Just caught the recording. Thanks so much - This was an excellent session .. really comprehensive front to back overview of Dataverse, with a couple of inside track nuggets thrown in there for good measure!... Great stuff!... 👏👏👏

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Great to hear!

  • @ankitbhatnagar697
    @ankitbhatnagar6972 жыл бұрын

    Thank you, Reza. It was on my watch list since the day you out up the post. Will complete this today, much awaited. 😁

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Hope you enjoy the video. Ryan gave the best introduction to Dataverse.

  • @kannankarmegam5559
    @kannankarmegam55592 жыл бұрын

    Thanks guys much appreciated.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Our pleasure!

  • @kannankarmegam5559
    @kannankarmegam55592 жыл бұрын

    Ryan Jones - oh god.. what a amazing presentation skill... I wish I have these...

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Ryan is awesome!

  • @nihar4713
    @nihar4713 Жыл бұрын

    This is so informative

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks

  • @vijaybhatia3024
    @vijaybhatia3024 Жыл бұрын

    Really appreciated sir

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks

  • @stevetilling3897
    @stevetilling38972 жыл бұрын

    Hey Reza, can you do a video on all the things that are not possible yet or that are not easy, especially for the low code audiance . Things that are currently driving me nuts in model driven apps are setting default values for fields, concatenating choice fields, duplicating records, charts that need to work with the full data set rather than time slice, pagination over 250 records, bulk updating an entire query, setting a field to use date() an on and on. You cover a lot of these odd usecases in your videos which is how i found you in the first place. All of the above i have been doing for over a decade in ms access and i am finding it really frustrating, thanks Reza

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Wow! That's a lot of pain points :) Will add it to my backlog. I will need a lot more requests on this topic to give this a higher priority.

  • @mohammedfakhri4289
    @mohammedfakhri42892 жыл бұрын

    Nice work Reza and Dan.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks for listening

  • @juandavila4035
    @juandavila40352 жыл бұрын

    I love your videos, all are very interested. About dataverse table and powerapps I think you are right, but I need to have more videos about them. Because I tried to create and move the data from SharePoint list to dataverse tables and change a lot of things. From my point of view the apps are better with dataverse

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I have more videos planned with Dataverse.

  • @juandavila4035

    @juandavila4035

    2 жыл бұрын

    @@RezaDorrani you are the best hahahaha

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@juandavila4035 :)

  • @hudsonquay
    @hudsonquay2 жыл бұрын

    Pretty cool that Eric Stoltz is also the Dataverse King.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    :)

  • @mehdialaoui19
    @mehdialaoui192 жыл бұрын

    Hi @Reza, Thank you for this awesome content, One quick question, I don't have in my Dataverse enviroment this powerFX formula type of field, Do I need something to enable it or is it an upcoming feature not yet available ? Thank you!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Ryan demonstrated a new feature around Power Fx for calculated columns. It is a feature that will be coming in future.

  • @FRANKWHITE1996
    @FRANKWHITE19962 жыл бұрын

    Subscribed ✅

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thank You 🙏

  • @726ashok
    @726ashok2 жыл бұрын

    Thanks for this useful video... Can you please tell us what are the differences between DataVerge, CDS and Azure SQL?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Check powerappsguide.com/blog/post/excel-vs-sharepoint-vs-dataverse-vs-sql-server

  • @HinaGeo
    @HinaGeo2 жыл бұрын

    Thank you so much for another great lesson. Do you please have videos on SharePoint framework development?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I have done no work with SPFx

  • @HinaGeo

    @HinaGeo

    2 жыл бұрын

    @@RezaDorrani Thank you for the reply.👍

  • @vinayaktiwari4383
    @vinayaktiwari43832 жыл бұрын

    When "SQL, excel, SP List" has a baby the product is "Dataverse" ! Creating deeper holes in customers pockets but better experience. q1) What is the pricing/licensing model for the data stored in it? Does cost increase with size and amount of data? q2) Good data is supports billions of rows > How how about querying that data for analysis ? eg. Count(Distinct(column)) > Do I expect to see throttling ? eg. 2 > my query return filtered 10 row > do i expect any throttling ?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    docs.microsoft.com/en-us/power-platform/admin/capacity-storage (licensing link is in web page)

  • @cnchandroo
    @cnchandroo2 жыл бұрын

    Dear Reza & Daniel As usual great session and Thanks to Ryan for his insightful session on Microsoft Dataverse. However, I couldn't able to ask questions on the live show, hence asking here. My question is: Whether it is possible to create a view in a parent table with multiple related tables in the Dataverse using joins like we normally do in SQL Server. If yes, could you please share some inputs on this? Thanks.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Sorry, but I do not know about this. You would have to ask this question directly to Ryan twitter.com/rjmax?s=21

  • @cnchandroo

    @cnchandroo

    2 жыл бұрын

    @@RezaDorrani Will check with Ryan. Thanks

  • @varunsinha7388
    @varunsinha73882 жыл бұрын

    Hi, thanks for video. Just curious how do i go about retrieving the audit logs of a table? i'd like to find out the changes made to a particular column on an audit-enabled custom table. thanks!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Ohhh. This is something I would need to learn more about as well. I will recommend checking on the forums at powerusers.microsoft.com/

  • @andrewtran772
    @andrewtran7722 жыл бұрын

    This is so helpful and informative! Any chance we could get a copy of Ryan's Dataverse slides?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Check pinned comment on video.

  • @andrewtran772

    @andrewtran772

    2 жыл бұрын

    @@RezaDorrani Awesome - thanks so much, Reza!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@andrewtran772 You are most welcome!

  • @Saadssk94
    @Saadssk942 жыл бұрын

    Hello Reza, ive just started using Dataverse and im having trouble to filter two level parent child relations without the presence of ID column. Im so confused working without an ID column and cannot find any result on google search whats the alternative to this?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Did you try posting your issue on the forums? powerusers.microsoft.com

  • @AltafRehmani
    @AltafRehmani2 жыл бұрын

    Dataverse is good - there are lack of Tools like a enterprise data manager for Dataverse - The power platform interface for querying data within dataverse has its limits. Any recommendations?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Im not sure about this one to be honest. You can try asking that to Ryan twitter.com/rjmax?s=21

  • @sebastiendebosscher
    @sebastiendebosscher2 жыл бұрын

    Hi Reza, how can we bulk MODIFY data in dataverse? With power query online we can INSERT and there is also a DELETE existing rows checkbox when importing data, but than you lose critical information like: date/time created. I know you can 'modify the data in Excel', but are there other options to bulk edit the data (I want to run a power query to do it)?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Great question. Something that I am not aware of :) I would recommend checking with Ryan Jones. www.linkedin.com/in/rjmax/

  • @DrueTucker
    @DrueTucker2 жыл бұрын

    Would you attach or link to the slide deck when you have a chance? Thanks!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I will provide the slide link soon. It would be a pinned comment on this video.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Check pinned comment on video

  • @DrueTucker

    @DrueTucker

    2 жыл бұрын

    @@RezaDorrani Thanks, Reza!

  • @RKTECH1021
    @RKTECH10212 жыл бұрын

    I have question regarding PowerApp environment. once it's default created in West US, how can I change region to East US. my synapse workspace and blob storage in East US. so in Dataverse, it doesn't let me connect to Synapse workspace through Azure Synapse link. Even I don't see options to choise US different region other than United States.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I believe there is no option to change environment location once created.

  • @mydogcheenu
    @mydogcheenu2 жыл бұрын

    Will you teach us how to attach the file in dataverse table from the form!!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Will add your topic suggestion to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.

  • @mydogcheenu

    @mydogcheenu

    2 жыл бұрын

    @@RezaDorrani Thank you

  • @naveedbhashani
    @naveedbhashani2 жыл бұрын

    Dear Sir i am facing the issue to connect my local sql database with power app? please advice and suggest the meaningful link so i could go moving forward.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I do not have any videos with SQL or any reference link. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @sarveshdahiya
    @sarveshdahiya Жыл бұрын

    @RezaDorrani - How do we archive dataverse data? What is the best practice?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    I have not done any work related to data archival. May be check on forums. powerusers.microsoft.com/t5/Microsoft-Dataverse/What-happened-to-Microsoft-Dataverse-data-archival/td-p/1439234

  • @quratulainmansoor8776
    @quratulainmansoor877610 ай бұрын

    can we use a power shell script to migrate data from the SharePoint list to Dataverse?

  • @RezaDorrani

    @RezaDorrani

    10 ай бұрын

    I am not sure about this. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @quratulainmansoor8776

    @quratulainmansoor8776

    10 ай бұрын

    @@RezaDorrani I have searched I suppose we can achieve this. You guys are doing great work. Have learnt a lot. ! JazakAllah Khair.

  • @YaryRivera
    @YaryRivera Жыл бұрын

    Hi. I need help. I have a virtual sql table in dataverse that I need to get column item counts for in my power app from a dropdown. How can I do this? Can you help me?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    I have not done any videos with virtual tables. You should be able to use countrows function.

  • @viveksingla4095
    @viveksingla40952 жыл бұрын

    can you please share that deck presented by Ryan

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Check pinned comment on video

  • @razakua
    @razakua2 жыл бұрын

    Hi Reza I’m looking for a training in power platforms. How can I contact you

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    reza.dorrani@outlook.com

  • @RezaDorrani

    @RezaDorrani

    10 ай бұрын

    Check channel memberships. I have gone live with a training tier that you can sign up for now. kzread.infojoin

  • @lztoniolo
    @lztoniolo2 жыл бұрын

    This means that MSFT Lists will be dead soon? Dam, I've just builted my business structure using Lists... :/ Too late

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Hopefully not. Lists are here to stay. Check out kzread.info/dash/bejne/g5VltbClo8Xcmbg.html