Today, a lot of data is in SAAS solutions in the cloud. Like SalesForce, Exact Online and Dynamics 365. To use this data in Power BI you need to connect to the data via a Web API (Web Service). This can be challenging if you have never done this before. In this video tutorial I…
The world of data engineering is changing. Being fluent in T-SQL is not enough anymore. Whether you want to implement a Delta Lake using Data Bricks, use Jupyter Notebooks to analyse your data or built a ETL pipeline in Microsoft Fabric, Python is the new kid on the block. In this demo filled video I…
– Import CSV File Import Parquet File
When writing Python code in notebooks there are a lots of packages that can be really useful to select and transform data like Pandas and PySpark. In this article you will learn how to get an overview of all the preinstalled packages and how to install new public packages from PyPi. PyPi PyPI, the Python…
Dataflows are ETL pipelines running in the Power BI Service or in a Fabric Workspace. What is the difference between Gen 1 and Gen 2 and how are they related to the normale Power Query engine inside Power BI Reports. Which new use cases wil the Gen 2 Dataflows give you in combination with a…
Spark is an important part of MS Fabric, especially if you are creating Lakehouses and want to execute Python code inside Notebooks. This code is executed by Spark Worker Nodes. This video will give you an introduction of the architecture and inner workings of this Spark Engine.
For a more in-depth tutorial: Call Web APIs like a pro in Power Query Today, a lot of data is in SAAS solutions in the cloud. Like SalesForce, Exact Online and Dynamics 365. To use this data in Power BI you need to connect to the data via a Web API (Web Service). This can…
M is the formula language behind Power Query and Dataflows. Every transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed when you only use the graphical interface. Find out here what it is and which scenario’s it is useful for to know more about…
When working with databases, connecting to REST API’s or getting data from storage accounts you need username/password, API Keys or other kind of secrets. Of course you can just put them hardcoded in the Notebook and run the code and forget about them and everything works fine. But what if you connect to the same…