dataMinds News Round up –
February 2024
Running into troubles while getting on-premises data into Microsoft Fabric using the data gateway? Reitse Eskens got you covered with a step-by-step walkthrough, including the issues he ran into.
The Fabric community vented a loud and clear necessity for certifications as it would help them upskilling to Fabric and provide the training needed to deploy Fabric in your organizations. Therefore, Kim Manis is excited to announce the beta availability of Exam DP-600: Implementing Analytics Solutions with Microsoft Fabric, which helps you earn the Microsoft Certified: Fabric Analytics Engineer Associate certification.
Next, she also introduces Fabric Career Hub: your one-stop-shop for professional growth, which includes tons of free on-demand and live training as well as access to exam discounts.
Microsoft Copilot for Microsoft 365 is now available for organizations of all sizes with Microsoft 365 and Office 365 — without a minimum license count.
In this video, Jeremy Chapman from the Microsoft 365 team demonstrates new security, compliance, and privacy updates in the experience. You’ll also see what’s possible to achieve the right level of file permissions for Zero Trust, just enough access search across Microsoft 365 and with Copilot information retrieval. Beyond data security, Jeremy explain prerequisites, administrative controls in the Microsoft 365 admin center, the wizard-based Copilot for Microsoft 365 setup guide, and tools to drive adoption.
Get ready for Copilot!
In this threefolded series, Sean Mirabile discusses the technical methods used to improve Data Pipeline Copy activity performance through parallelization by logically partitioning any source.
Solutions often leverage a single Copy Activity to move large volumes of data. While this works great, one might face a scenario where one needs to improve the performance by reducing the time it takes to move data into your Fabric Lakehouse.
To improve performance, instead of using a single Copy Activity to move a large volume of data, Sean shows you how multiple Copy Activities can move smaller volumes in parallel. It doesn’t matter if the source is a REST API, Blob Storage, or a Transactional Database. In many cases, logically partitioning the source data into buckets & copy each bucket over to the destination is the key to success.
Using runMultiple
in Microsoft Fabric notebook isn’t new. It was announced at MS Ignite in November 2023. But the Notebooks team has been quietly adding great features to it.
The notebook
class in mssparkutils has two methods to run notebooks – run
and runMultiple
. run
allows you to trigger a notebook run for one single notebook.
runMultiple
, on the other hand, allows you to create a Direct Acyclic Graph (DAG) of notebooks to execute notebooks in parallel and in specified order, similar to a pipeline run except in a notebook.
Did you ever use Semantic Link? It provides you with the ability to analyse Power BI data easily using Python in Fabric notebooks. Meanwhile in the Excel community, Microsoft recently introduced the new integration of Python into Excel. But can you analyse Power BI data in Excel using Python? Yes you can. Chris Webb is our tour guide for today!