Hello! We are a group of skilled developers and programmers.
data engineering
how to refresh individual tables or partitions in power bi semantic models from fabric data pipelines.
Refresh only the parts of your semantic model that you really need to!
how to call fabric rest apis from python notebooks.
Learn how to call Fabric REST APIs from python notebooks - from outside or within Fabric.
how to effectively determine the token resource URL (sometimes also referred to as audience or scope) for authentication.
In need for a Resource URL for authenticating to a service or data source? Read on.
how to reframe (“refresh”) your direct lake semantic model from fabric data pipelines.
Manually trigger a refresh of direct lake semantic models from fabric data pipelines!
how to pre-warm your power bi semantic model from fabric data pipelines.
Warm up the data in your semantic models with Fabric Data Pipelines!
how to create simple (and funny) semantic models that change its data with every refresh.
Get some simple to use mock-up data to test refreshes and other fabric and power bi features.
how to query and store meta data of your semantic model with sempy and dax info functions.
Store the meta data of your semantic models with the new native DAX info functions and Sempy in your Fabric Lakehouse.
how to call fabric rest apis from fabric data pipelines.
Learn how to call Fabric REST APIs from Fabric Data Pipelines!
how to call power bi rest apis from fabric data pipelines.
Learn how to call Power BI REST APIs from Fabric Data Pipelines!
how to create a date dimension table in python and pyspark.
Here comes a simple script for creating a simple date table.
how to load files from azure devops repository straight into power bi.
Load files from your Azure DevOps repository straight into Power BI in order to build your very own automated documentation.
how to query and copy data from power bi semantic models (former datasets) via azure data factory.
Learn how to query Power BI datasets with a client tool other than Power BI. Querying implies that you can even store the data somewhere else!
how to refresh power bi semantic models (former datasets), tables and partitions with azure functions.
Wanna learn how to refresh Power BI datasets or specific tables and partitions? Here an approach with Azure Functions and the TOM library.
how to use azure function and data factory for creating and managing partitions in azure sql database and power bi.
Mirror, mirror on the wall, align my partitions after all!
how to automate the management of custom partitions for power bi semantic models (former datasets).
Automated managing of partitions in Power BI? OHHH YES!!! Check out this blog for a script and a walk-through on custom partitioning in Power BI.
how to customize data factory triggers across environments with azure devops pipelines.
Customize your data factory triggers for each environment with releases from Azure DevOps pipelines!
how to get oauth2 access tokens for data sources via data factory to refresh power bi semantic models (former datasets).
Update oauth2 tokens for data sources from data factory right before refreshing datasets in Power BI!
how to manage azure-key-vault backed scopes in databricks.
Having trouble managing secret-scopes in Azure Databricks? Here comes an easy-to-us python script for that exact matter!
how to manage access control in azure databricks with SCIM API.
Establish a secure and easy-to-manage access control structure in your Azure Databricks Workspace with the SCIM API.
how to refresh power bi semantic models (former datasets) from data factory with managed identity.
Skip using service principles to authenticate Azure Data Factory to Power BI workspaces for dataset refresh API calls. Instead, use managed identity!
how to add adventureworks sample to azure sql database.
Sometimes you need a proper amount of data to test, lab or to be able to try out new features. This blog post shows you how to populate an Azure SQL Database with (the "real") AdventureWorks sample data (and not the lightweight version).