ππ±π©π₯π¨π«π’π§π ππ¨π°ππ« ππ πππ¦ππ§ππ’π ππ¨πππ₯ ππππ π―π’π πππ¦ππ² ππ²ππ‘π¨π§ & ππ‘π πππ¦ππ§ππ’π ππ’π§π€ π’π§ π πππ«π’π ππ¨ππππ¨π¨π€π¬:
β¨Semantic Link unlocks the potential to query data from Power BI's semantic models, which are already cleaned and refined into a gold models, using tools such as Pandas and Spark APIs.
This will provide a whole of possibilities for Data Scientists and ML applications.
In the bellow screenshots, we'll explore how to use the Semantic Link combined withΒ SemPy Python library within the Fabric workspace to readΒ data & metadata , evaluate measuresΒ from Semantic Models, and perform various operations.
Before starting we need to:
-Create a notebook in Fabric workspace
-Install the SemPy Python library in the notebook (check my screenshots)π
β¨The SemPy Python API interactsΒ with semantic models and executes queries on them. Let's explore some of the possibilities it offers:
β
List the available semantic models in the specified workspace.
β List the Tables/ Measures available in the specified semantic model
β
Read data from a specified Table
β
Evaluate measures and group them by specified fields
β
Add measures to External Data
πSame LinkedIn post: LinkedIn post
πPrevious post about this: https://lnkd.in/enqhikHh