Hi Scott, really like your videos. They are really usefull. Is it me or is the video from minute 9:15 not aligning with your talking!? I miss the visuals of what you are saying for the rest of the video...😢
@MSFT_ScottSewell3 күн бұрын
I missed this earlier. Let me see if I have the rest of the source video.
@gracielat24 күн бұрын
Great Video Scott ! thank you very much! i have a question, i'm having some troubles when i make my FabricLink, there are some table that aren't appearing it on Fabric and neither on my FabricLink in Dataverse, why could this happen?
@sonash466225 күн бұрын
Hi Scott, I have been able to successfully set up syanpse link but as soon as start selecting tables to load in Power BI , it throws a data source and binding error! Would be please be able to advice on how to resolve this errors?
@MeeluDannyАй бұрын
Hi, great video. I would like to check, if i made changes in the fields in the CRM Dynamics 365 ie, add or remove columns in the CRM report, would addition/deletion of columns reflect in the PBI report ?
@MSFT_ScottSewellАй бұрын
It all depends on the way you're querying the data - the best approach, defined queries, means you do need to update the query with the new fields. - An open, unfiltered query would allow new fields to show up, but would perform poorly always.
@saurabh7337Ай бұрын
Is it possible to create a virtual table in Dataverse based of a delta table in Fabric or Synapse SQL serverless pool or Azure Data lake storage account ?
@MSFT_ScottSewellАй бұрын
lots of options - check the docs - here's one conversation on it. learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-build-apps-with-fabric#create-a-virtual-table-with-fabric-data
Hi Scott, Thanks for this useful video for upserting records. Is there a video for implementing the same functionality with MS Fabric Warehouse table as the destination? I am trying to implement the feature MS Fabric Warehouse table but the Advanced Settings are different. There is no Write behaviour option and related settings. There is however, 'Pre-copy script' and Write batch timeout settings instead.
@MSFT_ScottSewellАй бұрын
The functionality delivers a lakehouse - if you'd like to copy that data into a warehouse, you can build your own pipelines to summarize, filter, supplement, and restructure the data into your own "sliver" layer there.
@shekaranju9069Ай бұрын
Hi Scott. do we need a dynamic license to create a Power BI Dashboard from Dynamics 365 data.? Please give some information or link.
@MSFT_ScottSewellАй бұрын
Yes - Accessing the data depends on a license to query the data.
@Patches3670Ай бұрын
Hi Scott - how would you extend this to enable RLS on multiple fact tables? Would you have a separate RLS permissions table for each fact?
@MSFT_ScottSewellАй бұрын
Probably - but typically multiple fact tables in a report would be an anti-pattern.
@Patches3670Ай бұрын
@@MSFT_ScottSewell Can you add a little detail? I have rarely seen a model with only a single fact..
@srijaniroychowdhury2 ай бұрын
does the data get updated automatically from ms 365 crm?
@MSFT_ScottSewell2 ай бұрын
@@srijaniroychowdhury yes, whenever the report is refreshed.
@redudire12362 ай бұрын
Thanks so much this is really helpful!!
@UnbelievableOdyssey2 ай бұрын
Can Fabric Link utilise the Direct Lake feature?
@MSFT_ScottSewell2 ай бұрын
Yes, but I might suggest only using it for extraordinarily large Dynamics datasets with very narrow/specific requirements. I would start with import or direct query methods first most Dynamics 365 use cases.
@dariom50733 ай бұрын
Genius! I've looked this for long. Thanks
@Mike-en1rd3 ай бұрын
Thank you for the great content! Ive been using your videos to build solutions for my company
@MSFT_ScottSewell3 ай бұрын
That’s always great to hear- thanks for letting me know.
@BryanCampbell8883 ай бұрын
hey Scott, any reason the stringmap table would be incomplete? As in missing rows?
@MSFT_ScottSewell3 ай бұрын
Publish all customizations from within dataverse and wait for the next synchronization. After waiting for a synchronization you can publish the table information to Fabric - I don’t think that’s necessary, but I always do it “for 🍀 luck!” 😀
@aleclippe62133 ай бұрын
i will watch and like every one of these series. thank you so much
@MSFT_ScottSewell3 ай бұрын
Glad you like them!
@LearnMicrosoftFabric3 ай бұрын
Thanks for this series Scott! Very interesting to see the upsert write behaviour available for the Dataverse connector 👀
@MSFT_ScottSewell3 ай бұрын
Thanks! - And I'm enjoying your series on your channel as well. - you're doing great work in breaking out the learning process for everyone including me. - Thanks for that!
@LearnMicrosoftFabric3 ай бұрын
@@MSFT_ScottSewell Ah no wories, thanks for watching Scott!
@katye_kat99533 ай бұрын
Is it possible to visualize data across several tables? Or is it limited to the one view/table?
@MSFT_ScottSewell3 ай бұрын
The view can contain data from multiple tables - however for more complex and interesting solutions, building a report in Power BI would be the approach.
@Mike-en1rd4 ай бұрын
Is there a reason you are using SQL Views rather than relying on DirectLake?
@MSFT_ScottSewell4 ай бұрын
Yes, the value of Direct Lake really shines in the hundred of millions of records to billions of records - in general from D365 CE at least, a few million records is on the larger size and may not fully benefit from DirectLake's strengths. Additionally, Direct Lake presumes the format of the data being read from the table is already ready to be mapped directly into the analytics table, but with Dynamics data there is often a need to join the stringmap table for option set labels which causes a direct lake query to fall back to direct query. - Direct Lake is certainly possible (I have a Direct Lake demo report with 9M support cases built as a POC), but in general for D365, I would consider it only for special purposes and build it knowing the constraints upfront.
@Mike-en1rd2 ай бұрын
@@MSFT_ScottSewell Thanks - I used Direct Query after reading your response
@BillsWorkbench4 ай бұрын
Thanks for your help showing us how to get started. I am finding that some of our custom tables are not linking in from Dynamics CRM (Sales) into the Synapse Link. Is there a video that hows how to link to custom tables in Sales?
@MSFT_ScottSewell4 ай бұрын
Only tables that have change tracking enabled can be exported. Here's how to enable change tracking on a table in Dataverse: - learn.microsoft.com/en-us/power-platform/admin/enable-change-tracking-control-data-synchronization
@BillsWorkbench4 ай бұрын
@@MSFT_ScottSewell Thank you! You are the wind beneath my keys.
@MSFT_ScottSewell4 ай бұрын
@@BillsWorkbench LOL
@nikolaskoumentis57992 ай бұрын
Hi and thanks for this video! Just one question because I'm confused with the documentation. If I want to synch F&O tables to One Lake, do I need Gen2 storage and Synapse workspace?
@MSFT_ScottSewell2 ай бұрын
@@nikolaskoumentis5799 not with the “Fabric Link” approach. - Azure resources are only needed if you use the “Synapse Link” method.
@rody691004 ай бұрын
Hi, When we link D365FO environment, to Synapse workspace or Microsoft Fabric, can we have out of the box access to D365FO aggregated tables (Fact tables and dimensions) like SSAS cubes?
@MSFT_ScottSewell4 ай бұрын
I think the question is combining some ideas in a way that makes it tough to answer. - I'd encourage you to engage with the community in the SynapseLink forum. aka.ms/SynapseLinkforDynamics
@kevincheek89614 ай бұрын
Just wanted to add an alternative to the DATEADD() which is to use something like the following: CAST([createdon] AT TIME ZONE 'UTC' AT TIME ZONE 'AUS Eastern Standard Time' AS DATETIME) This has the advantage of taking account of daylight saving time changes and so on, should it be an issue.
@kevincheek89614 ай бұрын
Thanks for the videos, I'm not sure how you figured all this out! I'd been using SQL endpoint to the CRM backend previously, and the codename fields were visible there, so was wondering what was going on when using Fabric linked data. Was good to know it wasn't something we'd done wrong, and how to get around it. 1 thing, if you happen to read this, my VS code doesn't fill in the AS field name like yours does, I'm guessing it's an add-in/extension. Any idea which one it might be? Thanks!
@MSFT_ScottSewell4 ай бұрын
I’ve got copilot enabled- maybe that’s it? Honestly at times it’s so good that it’s occasionally creepy. 😃
@MSFT_ScottSewell4 ай бұрын
Great to hear that it was helpful! Thank you for letting me know!
@finteija41584 ай бұрын
Great Video - Thanks so much! Would love if you made a video on how to recreate the Power Platform Admin center Analytics Graphs in BI using the new connector!
@MSFT_ScottSewell3 ай бұрын
I haven't checked the learn.microsoft.com/en-us/power-platform/guidance/coe/overview Center of Excellence, but they are always improving and expanding that.
@nsulliivan4 ай бұрын
Hi Scott! Using the SQL Endpoint to create the views and bring in data with the SQL connection in PBI is really sharp! How do you prioritize between the give and take of SQL Views and import mode (or direct query) vs. creating a semantic model with lakehouse delta tables and 'Direct Lake' connections? I could see views being a choice that would typically be import mode but highly customizable, and Direct Lake being a choice where we don't need model refreshing - BUT your tables might have tons of CRM fields that aren't needed, or less custom setup like customer and owners?
@Mike-en1rd4 ай бұрын
I would love an answer to this as well.
@MSFT_ScottSewell4 ай бұрын
See my response to the other DL question - I am mostly just glad that we have options to choose from. - Direct Lake is very impressive for massive datasets, but isn't the first choice for me when it comes to ease of use and re-usability in a D365 context which typically needs some data engineering/structuring before it's ready to go into the analytics table.
@anshikaagrawal99734 ай бұрын
I have gone through your full series and it is wonderful. It helps me atleast taking a high level overview of what is azure synapse link for dataverse.
@SilvanoPaxia5 ай бұрын
Great Video As usual! If I understood properly by creating a link t Fabric in Dataverse we replicate from Dataverse to Fabric, while if we have a shortcut the data are not replicated, is this correct?
@MSFT_ScottSewell5 ай бұрын
not quite. - In both cases, shortcuts are created in Fabric that point to the data stored in the Microsoft OneLake inside Dataverse. - The Link has to be established in Dataverse in order to populate the internal data lake - once that's populated, additional custom links from Fabric can be added.
@aleclippe62135 ай бұрын
My god Scott, please stop putting these out for free😭 I feel like I’m holding you at gunpoint to get these gems out every week .
@MSFT_ScottSewell5 ай бұрын
Lots of excitement around Dataverse + Fabric
@aleclippe62135 ай бұрын
@@MSFT_ScottSewell I bet on it a year ago and became the best I could ever since then (started power platform 3 years ago). I work for a 60,000 person company as an AI/ RPA lead and am gonna change its infrastructure brick by brick with it! Love it and love your content!
@BlackSmith11555 ай бұрын
Great video, thanks for sharing Scott. Do we need to created synapse link profiles prior to creating the shortcuts in Fabric? Also is that a preview feature, as I don’t see Dataverse as a shortcut option when I go to shortcuts?
@BigDataSport5 ай бұрын
How can I enable Azure Synapse Analytics workspace, I am not viewing this option on my tenant
@MSFT_ScottSewell3 ай бұрын
You'll need to create it in Azure. - The installation guide provides some insight, but you might need to pull together docs from several sources. - That's part of the reason the Fabric-Link approach is so attractive, there's so little you need to do to configure it.
@erwinsanders4075 ай бұрын
Hi scott I have a dev test and prod environment. When i want to embed the powerbi report into dynamics how can it connect to the database / server for every environment?
@MSFT_ScottSewell5 ай бұрын
You'll need a dev, test and prod Power BI set up as well. I currently manage the repointing manually since ALM would be a bit more overhead for my use case. I'd encourage you to take a look at the solution management documentation for one approach of deploying from dev to test to prod - It's a preview feature, but it's an option. learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-edit-powerbi-report-dataset-components Best of luck, for more details, I'd encourage you to work with an experienced partner - each customer's situation is more complex than can be managed in a youtube comment. 😀
@aleclippe62135 ай бұрын
300 views is absolutely criminal. You are amazing sir!
@dineshs96706 ай бұрын
Is it possible to configure this for fabric workspace which is in external domain.
@martineausolicitors6 ай бұрын
Great video! Super easy to follow and worked a treat!
@eddieflyer5556 ай бұрын
Great insights from this video series😀! Thanks for putting together!
@ericcoffman76346 ай бұрын
Are there any additional costs besides the Fabric Capacity license to utilize and view the Dataverse data?
@MSFT_ScottSewell6 ай бұрын
None
@erwinsanders4076 ай бұрын
Is it posible to embed the powerbi report in dynamics in a way that its environment aware ( deploy it from dev to prod )
@MSFT_ScottSewell6 ай бұрын
Yes - check the docs for solution aware Power BI reports. - The feature is in preview, and may change again before GA.
@saurabh7337Ай бұрын
@@MSFT_ScottSewell Do you have a reference document to share on "solution aware Power BI reports" ?
@erwinsanders4076 ай бұрын
Hallo scott i like the explanations. How is the security of the data taking care. Can the user Who is using the report only see the data which he normale could see via dynamics ?
@MSFT_ScottSewell6 ай бұрын
See this video: kzbin.info/www/bejne/onu0mYqPa6qjbaM
@sheilahart75286 ай бұрын
Thanks for this series on Dataverse!! I didn't realize it would be so easy to setup the connection.
@MSFT_ScottSewell5 ай бұрын
Great to hear!
@BhupendraPatel19786 ай бұрын
Brilliant, Scott !! what are the extra charges we need to pay in this case is there any size limitations for creating the delta lake within DV env.