Hello! We are a group of skilled developers and programmers.
tackytechtom
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 set a service principal as the owner of a power bi semantic model (former dataset).
Want to assign ownership of a Power BI dataset to a service principal? Well, you have come to the right place: Just follow this tutorial!
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 swiftly take over Power Query with the help of some useful gear.
Pow! Pow! Power Query! Check out this blog post providing some proper gear for solving some of the most common issues in Power Query and M.
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 crack the mystery of the mighty DAX.
Let's deep dive into some useful DAX on special and recurring matters. Have a look into this cheat sheet now and then since it will be updated constantly.
why the precedence of calculation groups is so important.
Calculation groups are very powerful, but only if applied properly. Make sure to set proper precedencies when using multiple calculation groups in a model.
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 get the latest exchange rates straight into power bi.
When currencies suffer fluctuation, it is crucial to fetch the right figures in real time. Get them straight into your Power BI model with this tutorial.
how to create summary stats with calculation groups.
Yet, another example on how you can use calculation groups: Get some simple stats from your dataset by just choosing the function in need from a slicer or filter.
how to debug visual studio tabular model projects in power bi.
A simple and proven way to debug and examine efficacy of a tabular model in Visual Studio, is to use the “Analyze in Excel” function. It is, however, also feasible to test the project in Power BI without deploying the model. This blog post shows you how.
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).
welcome.
This is the start of my blog "tacky tech" about data, business intelligence and Azure. A sweet welcome to y’all! posts.