Пікірлер
@florisvanderzwaard4163 4 күн бұрын
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_ScottSewell 3 күн бұрын
I missed this earlier. Let me see if I have the rest of the source video.
@gracielat 24 күн бұрын
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?
@sonash4662 25 күн бұрын
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
@RobertCOliveirabh05 Ай бұрын
How can I enable this option in D365?
@MSFT_ScottSewell Ай бұрын
learn.microsoft.com/en-us/power-apps/user/visualize-in-power-bi
@rkneti Ай бұрын
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..
@srijaniroychowdhury 2 ай бұрын
does the data get updated automatically from ms 365 crm?
@MSFT_ScottSewell 2 ай бұрын
@@srijaniroychowdhury yes, whenever the report is refreshed.
@redudire1236 2 ай бұрын
Thanks so much this is really helpful!!
@UnbelievableOdyssey 2 ай бұрын
Can Fabric Link utilise the Direct Lake feature?
@MSFT_ScottSewell 2 ай бұрын
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.
@dariom5073 3 ай бұрын
Genius! I've looked this for long. Thanks
@Mike-en1rd 3 ай бұрын
Thank you for the great content! Ive been using your videos to build solutions for my company
@MSFT_ScottSewell 3 ай бұрын
That’s always great to hear- thanks for letting me know.
@BryanCampbell888 3 ай бұрын
hey Scott, any reason the stringmap table would be incomplete? As in missing rows?
@MSFT_ScottSewell 3 ай бұрын
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!” 😀
@aleclippe6213 3 ай бұрын
i will watch and like every one of these series. thank you so much
@MSFT_ScottSewell 3 ай бұрын
Glad you like them!
@LearnMicrosoftFabric 3 ай бұрын
Thanks for this series Scott! Very interesting to see the upsert write behaviour available for the Dataverse connector 👀
@MSFT_ScottSewell 3 ай бұрын
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!
@LearnMicrosoftFabric 3 ай бұрын
@@MSFT_ScottSewell Ah no wories, thanks for watching Scott!
@katye_kat9953 3 ай бұрын
Is it possible to visualize data across several tables? Or is it limited to the one view/table?
@MSFT_ScottSewell 3 ай бұрын
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-en1rd 4 ай бұрын
Is there a reason you are using SQL Views rather than relying on DirectLake?
@MSFT_ScottSewell 4 ай бұрын
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-en1rd 2 ай бұрын
@@MSFT_ScottSewell Thanks - I used Direct Query after reading your response
@BillsWorkbench 4 ай бұрын
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_ScottSewell 4 ай бұрын
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
@BillsWorkbench 4 ай бұрын
@@MSFT_ScottSewell Thank you! You are the wind beneath my keys.
@MSFT_ScottSewell 4 ай бұрын
@@BillsWorkbench LOL
@nikolaskoumentis5799 2 ай бұрын
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_ScottSewell 2 ай бұрын
@@nikolaskoumentis5799 not with the “Fabric Link” approach. - Azure resources are only needed if you use the “Synapse Link” method.
@rody69100 4 ай бұрын
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_ScottSewell 4 ай бұрын
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
@kevincheek8961 4 ай бұрын
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.
@kevincheek8961 4 ай бұрын
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_ScottSewell 4 ай бұрын
I’ve got copilot enabled- maybe that’s it? Honestly at times it’s so good that it’s occasionally creepy. 😃
@MSFT_ScottSewell 4 ай бұрын
Great to hear that it was helpful! Thank you for letting me know!
@finteija4158 4 ай бұрын
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_ScottSewell 3 ай бұрын
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.
@nsulliivan 4 ай бұрын
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-en1rd 4 ай бұрын
I would love an answer to this as well.
@MSFT_ScottSewell 4 ай бұрын
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.
@anshikaagrawal9973 4 ай бұрын
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.
@SilvanoPaxia 5 ай бұрын
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_ScottSewell 5 ай бұрын
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.
@aleclippe6213 5 ай бұрын
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_ScottSewell 5 ай бұрын
Lots of excitement around Dataverse + Fabric
@aleclippe6213 5 ай бұрын
@@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!
@BlackSmith1155 5 ай бұрын
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?
@BigDataSport 5 ай бұрын
How can I enable Azure Synapse Analytics workspace, I am not viewing this option on my tenant
@MSFT_ScottSewell 3 ай бұрын
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.
@erwinsanders407 5 ай бұрын
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_ScottSewell 5 ай бұрын
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. 😀
@aleclippe6213 5 ай бұрын
300 views is absolutely criminal. You are amazing sir!
@dineshs9670 6 ай бұрын
Is it possible to configure this for fabric workspace which is in external domain.
@martineausolicitors 6 ай бұрын
Great video! Super easy to follow and worked a treat!
@eddieflyer555 6 ай бұрын
Great insights from this video series😀! Thanks for putting together!
@ericcoffman7634 6 ай бұрын
Are there any additional costs besides the Fabric Capacity license to utilize and view the Dataverse data?
@MSFT_ScottSewell 6 ай бұрын
None
@erwinsanders407 6 ай бұрын
Is it posible to embed the powerbi report in dynamics in a way that its environment aware ( deploy it from dev to prod )
@MSFT_ScottSewell 6 ай бұрын
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" ?
@erwinsanders407 6 ай бұрын
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_ScottSewell 6 ай бұрын
See this video: kzbin.info/www/bejne/onu0mYqPa6qjbaM
@sheilahart7528 6 ай бұрын
Thanks for this series on Dataverse!! I didn't realize it would be so easy to setup the connection.
@MSFT_ScottSewell 5 ай бұрын
Great to hear!
@BhupendraPatel1978 6 ай бұрын
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.