Hi Lisa. I've seen that Fabric can link to Dataverse without copying data. However. I have diffkcuilty finding If the goals can be met -Having Lakehouse OR Datawaerhouse data from Fabric available in Dataverse? -Having Dataverse data available in a Lakehouse OR Datawarehouse. -Havkng Power Bi being able tl pull data from Lakehouse/Datawarehouse/Dataverse. There are probably limitatilns here and in Fabric they mention shortcut or link to Dataverse or do you have to use ADSL gen 2 to actually copy the data? Datalake and Datawarehouse probably handles this differently knowing Microsoft 😅 (Microsoft not even bekng able to do a proper GUI for file/table explorer in Fabrkc and Databricks or leaving out options in menus so you think there are limitations when in fact there aren't)
Great video Lisa! You've inspired me to use a model driven app solution for a project I'm working on and you're videos have been instrumental in helping me get my head around this awesome tool. Thanks for sharing and I'm looking forward to seeing more of your videos in the future!
Help.. we are trying to solve a mystery on tenant. We have a bunch of custom tables created on Dataverse, but our admins are saying they never created them and apparently users don't have rights to create tables. How could this have happened. I've checked power apps add data feature and don't see a way to create new tables.. and it seems only admins can create tables.
Lisa I hope you can help me with some information that is not clear in Microsoft about Dataverse... Does it is expensive to build a CRM in Model Driven Apps with Dataverse, because I am working with that but I'm afraid that it will get to expensive... The information in Microsoft is not very clear and would like to know how much does it cost to have more space and the space by default how much does i have.
I can’t find a tutorial for this. Do you have one? Run document through AI model and extract fields and tables and then put them into the data verse. This seems like it should be easy but I don’t know if you have to pre make your tables to exactly match your AI model, or can the AI model determine the table based on how you tagged it?
Some of your screens seem to show Dynamics forms with a Power Apps heading, certainly when you are talking about the security roles - very confusing. I can't find this menu even when going to the Power Platform Admin area.
Power Apps is the toolset for configuring Dynamics 365 because Dynamics 365 is built on Dataverse - it's a first party sophisticated model-driven Power App. The Power Platform Admin Center Menu has changed a bit since I recorded this so it may look slightly different now.
If you want to add and modify data on a spreadsheet you can do that using Power Automate. A bot can be used to call or trigger a Power Automate flow, but if you just want something done on a daily basis you can do that in Power Automate without the bot, use a timer trigger that automatically runs the flow daily.
I need your help and support, and I’m asking it out loud. Requirement is that I want to consume O365 license details For example- (Office 365 E1, Office 365 E3, Office 365 F3, etc ) from Live Tenant into Dataverse. Is there any standard connector in the Power app that I can consume from O365 to Dataverse? If not, please suggest to me what is the way to consume O365 Licence details.
It's done using Dual-Write -you'll find the details here learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/dual-write/dual-write-home-page
Hello Lisa, What is better to work with, dataverse or sharepoint library, when my data are files of 100 buildings, each building contains 100 folders and 200 subfolders. Example: Building: Empire State Folder: contracts, lisense, architect drawing.... Etc Sub folder: License/Fire, Licence/Health etc. 100 buildings x 100 folders x 200 subfolders with new, updated information. So Dataverse or SP libraries
If you are storing files in folders then SharePoint is the right tool for that, it's a document library. Dataverse is a database for storing rows of data.
I'm confused as to why you can't just enter data straight into a Dataverse table. Why do you HAVE to go through a form? This is where Airtable (and Lists) have it right - enter content directly OR through a form. I wish Lists was built on Dataverse and you had the choice to build apps off it. Rather than having Lists over here and PowerApps/Dataverse over there.
You actually can enter data straight into the Dataverse table directly (make.powerapps.com, navigate to the table, and you can do it there in a format which is pretty much exactly the same as lists). I just didn't cover it here. I'll do another video to show that.
Hey Lisa, thanks for this video. Is it possible to have Accordian view of the table view based on a groupby column in Model Driven Apps? Like we can implement in Canvas App to have a gallery expand and collapse (Accordian) based on a groupby column, do we have something of that sort in Model Driven Apps as well? I have set up a group by option in a editable grid using MS docs but I would love to see that in one your next videos and also I cannot make the view read-only with groupby option. If you can highlight that part as well, that would be great. Waiting for your response
Awesome. How does the Dataverse licensing work, please. Is there a limit on the number of records or number of tables? Thank you Lisa. Look forward to a video on power pages and Dataverse 😀
Thanks for the video. I have an database which have tables - Account, Contact, Team_Partners Now i want to sync this data with microsft dynamics. Can you please let me know the steps i should follow?
Lisa, I really LOVE your teaching style. You make this easier for me to understand. It feels relatable and very fun. Thank you for your vids!!!
❤
Thanks so much 😊
Hi Lisa.
I've seen that Fabric can link to Dataverse without copying data.
However.
I have diffkcuilty finding If the goals can be met
-Having Lakehouse OR Datawaerhouse data from Fabric available in Dataverse?
-Having Dataverse data available in a Lakehouse OR Datawarehouse.
-Havkng Power Bi being able tl pull data from Lakehouse/Datawarehouse/Dataverse.
There are probably limitatilns here and in Fabric they mention shortcut or link to Dataverse or do you have to use ADSL gen 2 to actually copy the data? Datalake and Datawarehouse probably handles this differently knowing Microsoft 😅
(Microsoft not even bekng able to do a proper GUI for file/table explorer in Fabrkc and Databricks or leaving out options in menus so you think there are limitations when in fact there aren't)
Great !!! Ms. Liza's educational video are very comprehensive. I would enjoy watching and learning more from her videos.
Great video Lisa! You've inspired me to use a model driven app solution for a project I'm working on and you're videos have been instrumental in helping me get my head around this awesome tool. Thanks for sharing and I'm looking forward to seeing more of your videos in the future!
Thank you so much Ant, that's awesome, and I'm very glad my videos have helped you. Plenty more to come in future, thanks for the support.
Thank you Lisa! Saving my MB700 architect test tomorrow!
Help.. we are trying to solve a mystery on tenant. We have a bunch of custom tables created on Dataverse, but our admins are saying they never created them and apparently users don't have rights to create tables. How could this have happened. I've checked power apps add data feature and don't see a way to create new tables.. and it seems only admins can create tables.
Lisa I hope you can help me with some information that is not clear in Microsoft about Dataverse... Does it is expensive to build a CRM in Model Driven Apps with Dataverse, because I am working with that but I'm afraid that it will get to expensive... The information in Microsoft is not very clear and would like to know how much does it cost to have more space and the space by default how much does i have.
Lisa you just blow my mind. Amazing job very helpful. Thnaks
Thanks so much 😊
Hi Lisa, Could you please suggest how can I send data/table from power to SQL and it should be automatically going forward? thank you very much.
I can’t find a tutorial for this. Do you have one? Run document through AI model and extract fields and tables and then put them into the data verse. This seems like it should be easy but I don’t know if you have to pre make your tables to exactly match your AI model, or can the AI model determine the table based on how you tagged it?
Some of your screens seem to show Dynamics forms with a Power Apps heading, certainly when you are talking about the security roles - very confusing. I can't find this menu even when going to the Power Platform Admin area.
Power Apps is the toolset for configuring Dynamics 365 because Dynamics 365 is built on Dataverse - it's a first party sophisticated model-driven Power App. The Power Platform Admin Center Menu has changed a bit since I recorded this so it may look slightly different now.
Can I let my Copilot studio Bot add and modify data on an excel sheet exist on onedrive on daily basis
If you want to add and modify data on a spreadsheet you can do that using Power Automate. A bot can be used to call or trigger a Power Automate flow, but if you just want something done on a daily basis you can do that in Power Automate without the bot, use a timer trigger that automatically runs the flow daily.
Can you create tables etc with code ( something like t-sql)? This will allow you to integrate with Git etc.
Great explanation Lisa, thank you once again! Now I know. The Universe secrets are in the Dataverse
LOL, indeed they are!
I need your help and support, and I’m asking it out loud.
Requirement is that
I want to consume O365 license details For example- (Office 365 E1, Office 365 E3, Office 365 F3, etc ) from Live Tenant into Dataverse.
Is there any standard connector in the Power app that I can consume from O365 to Dataverse? If not,
please suggest to me what is the way to consume O365 Licence details.
That was a great intro - good pace and level of detail. Thanks!
Glad it was helpful, thanks so much
Thank you for the information!
Hi, does D365 F&O also sync data to dataverse?
It's done using Dual-Write -you'll find the details here learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/dual-write/dual-write-home-page
Love this Lisa! Thanks so much for this info - I'm sure loads of people will try it out!
Hi Audrie, lovely to hear from you, thanks so much for watching, and certainly hope it reaches loads of people who will give it a go.
Hello Lisa, What is better to work with, dataverse or sharepoint library, when my data are files of 100 buildings, each building contains 100 folders and 200 subfolders. Example:
Building: Empire State
Folder: contracts, lisense, architect drawing.... Etc
Sub folder: License/Fire, Licence/Health etc.
100 buildings x 100 folders x 200 subfolders with new, updated information.
So Dataverse or SP libraries
If you are storing files in folders then SharePoint is the right tool for that, it's a document library. Dataverse is a database for storing rows of data.
@@LisaCrosbie OK, but when I have 100000 records en work with powerapps, how do I work with the max 2000 records delegation in a search?
And what works better Document/Record Center, or working with metadata in dataverse and the document in a library?
I'm confused as to why you can't just enter data straight into a Dataverse table. Why do you HAVE to go through a form?
This is where Airtable (and Lists) have it right - enter content directly OR through a form.
I wish Lists was built on Dataverse and you had the choice to build apps off it. Rather than having Lists over here and PowerApps/Dataverse over there.
You actually can enter data straight into the Dataverse table directly (make.powerapps.com, navigate to the table, and you can do it there in a format which is pretty much exactly the same as lists). I just didn't cover it here. I'll do another video to show that.
very good explanation Thank you!
thanks for jumping right to it. Liked and subscribed
Awesome, thanks for the feedback.
Thank you for sharing, 🤓
Hey Lisa, thanks for this video. Is it possible to have Accordian view of the table view based on a groupby column in Model Driven Apps? Like we can implement in Canvas App to have a gallery expand and collapse (Accordian) based on a groupby column, do we have something of that sort in Model Driven Apps as well? I have set up a group by option in a editable grid using MS docs but I would love to see that in one your next videos and also I cannot make the view read-only with groupby option. If you can highlight that part as well, that would be great. Waiting for your response
Great video, thanks for sharing Lisa.
Thanks for watching
Awesome. How does the Dataverse licensing work, please. Is there a limit on the number of records or number of tables? Thank you Lisa.
Look forward to a video on power pages and Dataverse 😀
Thanks for the video.
I have an database which have tables - Account, Contact, Team_Partners
Now i want to sync this data with microsft dynamics.
Can you please let me know the steps i should follow?
I see $$$$ adding up with each new concept she mentions.
Sehr gut danke
Better than Microsoft explains it.
Thanks ☺️
Amy Schumer?!
???