Introduction to Semantic Link in Microsoft Fabric

No video

Introduction to Semantic Link in Microsoft Fabric

Рет қаралды 5,368

Learn Microsoft Fabric with Will

Күн бұрын

Пікірлер: 32

@LearnMicrosoftFabric 10 ай бұрын

Want to learn more about Semantic Link, I just released a new 1hr workshop on Semantic Link: kzfaq.info/get/bejne/jtBgdNGLnde4ZWw.html

@LearnMicrosoftFabric 10 ай бұрын

A big thanks to Markus and his team for this one! How will you be using Semantic Link?! So many opportunities!

@simonloughnane6683 10 ай бұрын

This is very exciting. Lots of possibilities. Perhaps a slightly prosaic use-case, but I can see this coming in very handy for documenting our semantic models.

@LearnMicrosoftFabric 10 ай бұрын

It's as if you are reading from my list of future videos I am creating on Semantic Link, Simon! I think documenting Power BI models is a great use case - watch this space.

@douglasspencer9819 9 ай бұрын

Thank you for this valuable review of Semantic Link. IMHO: Semantic link feels a bit like a solution in search of problems that should ahve already been resolved in ETL. You do your data validations there, you do your fact and dimension value validations and violation alerts....so this should all be done long before you ever get your data into your data warehouse. As for updating your data sets...this can easily be done in a powershell script using a couple restAPIs and you then execute a sroc that runs the powershell script to update your dataset... Getting meta data on your datasets...yeah I see some value here that alleviates some manual work. The biggest benefit that I see is allowing other data consumers access to your measures, and of course helping these consumers get insight into the dax that created the measures.

@LearnMicrosoftFabric 9 ай бұрын

Hey thanks for your thoughtful comments! You're right in that there are many places in an end-to-end pipeline where we should be doing data validation, with most of the validation being done as upstream as possible. However I do see a place for semantic link in validating that semantic models are built and functioning as designed (how/where else would you validate this?). For example, those measures you mentioned written by a Power BI Dev, it would be nice to consistently monitor the outputs of these measures, and also cross table relationships too.

@vibhatt2512 5 ай бұрын

Very interesting feature...its indeed going to be a competitive advantage for Microsoft

@LearnMicrosoftFabric 5 ай бұрын

It's so useful and they are adding even more capability to it regularly too, I need to record an update video... 🙌

@MrSith-yp3yq 10 ай бұрын

Hi Will. I really like the format of the video, how you organize it. It was very valuable, thank you.

@LearnMicrosoftFabric 10 ай бұрын

Thanks for watching!

@LiseHolck 10 ай бұрын

Great video 😊. I would very much like to ser more videos on the data validation scenarios 👍

@LearnMicrosoftFabric 10 ай бұрын

Thanks! will definitely be covering that v soon ☺️

@shashipaul6279 10 ай бұрын

Great session indeed ....... Really found it interesting and going to follow each video you post in future related to this. .. ...

@LearnMicrosoftFabric 10 ай бұрын

Thanks shashi! You might enjoy this follow up video kzfaq.info/get/bejne/jtBgdNGLnde4ZWw.html

@kennethwaynescott8469 10 ай бұрын

Great stuff, Will. Appreciate all you work on this stuff.

@LearnMicrosoftFabric 10 ай бұрын

Hey thanks for the comment Kenneth! And no worries - I actually really enjoy making them and exploring all the new ways to use these amazing tools!

@aydinitil9061 9 ай бұрын

the biggest benefit i see from this is the ability to write tests in python on your dataset

@LearnMicrosoftFabric 9 ай бұрын

That is absolutely where I see the bigest benefit too - you should watch this video next where i talk in detail about data validation strategies using semantic link kzfaq.info/get/bejne/jtBgdNGLnde4ZWw.html

@samirsahin5653 10 ай бұрын

This is a great future. Would be great to access datasets and measures with no limitations. Previously, when we wanted to use data from a power bi matrix, we needed to export csv and there was row limitations. Now we will able to access it without export and use in a cycle. Can you do a deep dive video for dax for above scenario? Thanks for the video.

@LearnMicrosoftFabric 10 ай бұрын

Hey! Yes, I’ll be covering these aspects in more detail soon ☺️

@rabihbadr54 5 ай бұрын

Great videos. Cheers!

@LearnMicrosoftFabric 5 ай бұрын

Thanks for watching!

@Nalaka-Wanniarachchi 6 ай бұрын

Exciting one.

@LearnMicrosoftFabric 5 ай бұрын

It sure is! Has you used semantic link yet?

@AndyKabeer 10 ай бұрын

exciting video, thanks a lot it will be great to see if you can do a video on EDA( Exploratory data analysis) using Fabric Notebook and Power BI with analysis that we can currently do with Panda Profile or Sweet Viz and maybe then take it to one further and create a machine learning ( selecting the right model for the right use case, training/testing, etc)

@LearnMicrosoftFabric 10 ай бұрын

Thanks Andy, yeh absolutey I think there's a lot of scope to do EDA directly on Power BI datasets now - I'm on the case :) And yeh defo plan on doing an ML video: getting data from Power BI, training a model, writing predictions back to Lakehouse and then integrate into your Power BI visualisations. Thanks for your comment!

@AndyKabeer 10 ай бұрын

Awesome!

@crixcel8388 5 ай бұрын

Hey how to export these table in csv or documentation purpose , I am Unable to export these data frames in any format

@LearnMicrosoftFabric 5 ай бұрын

Not sure I understand the question? are you looking to export a CSV of the data returning by semantic link? You should be able to write out the dataframe using the pandas df.to_csv('Files/file_path')

@BharathKumar-ch4tp 4 ай бұрын

How can I use semantic link in python script outside of fabric environment

@LearnMicrosoftFabric 4 ай бұрын

Last time I checked I think it was a NO. Because the fabric notebook handles all the authentication for you.

@BharathKumar-ch4tp 4 ай бұрын

@@LearnMicrosoftFabric we can create service principale and authenticate right? Or is there any way that I can access semantic model data outside of fabric environment using programming languages? Thanks in advance