Power BI Workbooks
In this tip we look at how to work with Power BI workbooks and in the previous tip we looked at working with Power BI datasets.
Koen Verbeeck is a seasoned business intelligence consultant with over a decade of experience with the Microsoft Data Platform. He holds several certifications, including Azure Data Engineer. He's a prolific writer, with over 375 articles on technologies such as Microsoft Fabric, SSIS, ADF, SSAS, SSRS, MDS, Power BI, Snowflake and Azure services. He has spoken at various events such as PASS, SQLBits, dataMinds Connect and many others. He frequently delivers educational webinars on MSSQLTips.com. For his efforts, Koen has been awarded the Microsoft MVP data platform award for many years.
- MSSQLTips Awards:
- Leadership Award (200+ Tips) - 2021
- Author of the Year - 2014/2020/2022
- Author Contender - 2024/2025
Power BI Datasets
In this tip we look at how to work with Power BI datasets and in the next tip we will look at working with Power BI workbooks.
How to Create a Pareto Chart in Power BI Desktop
In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.
SQL Server Best Practices for Index Column Order and Money Data Type
In this tip we look at some additional best practices questions for SQL Server such as using the money data type, column order of indexes and more.
SQL Server Development Best Practices Webcast – Q&A – Part 1
In this tip we cover some answers to questions that were asked during the SQL Server Development Best Practices webcast on MSSQLTips.
SSIS Catalog Maintenance in the Azure Cloud
The SSISDB database can grow large when using Azure Data Factory and in this tip we look at how to setup maintenance to prevent this from occurring.
How to use @@ROWCOUNT in SQL Server
Discover the power of @@ROWCOUNT in SQL Server to easily find the number of affected rows after your SQL operations.
Using Files Stored in Azure File Services with SSIS – Part 2
In this second tip we look at how to use files stored in Azure File Services using SQL Server Integration Services.
Things I Wish I Knew When I Started My Business Intelligence Career
In this tip Koen Verbeeck shares things he has learned over the years related to business intelligence that he wish he knew when he first started working with SQL Server.
Using Files Stored in Azure File Services with SSIS
In this tip we look at how to use files stored in Azure File Services using Azure Data Factory.
SQL Server IN vs EXISTS
In this tip we take a look at the how to use EXISTS and IN when building queries in SQL Server.
Refresh Power BI Dataset using Azure Logic Apps – Part 2
In this tip we'll discuss how we can create an Azure Logic App which is going to be started from an Azure Data Factory pipeline that will refresh a Power BI dataset.
Refresh Power BI Dataset from Azure Data Factory – Part 1
In this tip we look at how to setup Azure Data Factory to communicate with Power BI to refresh the dataset so Power BI has the latest data.
Send Notifications from an Azure Data Factory Pipeline – Part 2
When you run a pipeline in Azure Data Factory you typically want to be notified for successful or failure. In this tip we will integrate this notification into an Azure Data Factory (ADF) pipeline.
Azure Data Factory Pipeline Email Notification – Part 1
Learn how to send notifications and alerts from Azure Data Factory using the Web Activity and an Azure Logic App.
Azure-SSIS Integration Runtime Startup and Shutdown with Webhooks
In this second part of this tip series we will look into further automation of this solution by calling the runbook from an Azure Data Factory pipeline through webhooks.
Start an Azure Logic App Workflow on Demand or by an Event
Learn different ways to start a Logic App Workflow for running tasks on Azure.
Transfer Files from SharePoint To Blob Storage with Azure Logic Apps
In this tip we will use Azure Logic Apps to fetch files from SharePoint, dump them into Azure Blob Storage and then copy the data into the database using the Copy Activity in ADF.
Automate Azure-SSIS Integration Runtime Startup and Shutdown
In this tip we will see how to automatically start your IR at the beginning of an ETL flow (using an Azure Data Factory pipeline) and how to turn it off at the end.
Use Azure Data Factory to Load On-premises Data – Part 2
In this part of this tip series we will use this set up in a practical use case: we're going to read data from the local server and push it to Azure Blob storage in an ADF pipeline.
Use Azure Data Factory to Load On-premises Data – Part 1
Learn how to connect to on-premises data sources using a pipeline in Azure Data Factory.
Parallel package execution in Azure-SSIS Runtime
In this tip we look at how to have SSIS packages run in parallel when executing in Azure using the Azure-SSIS runtime.
Customized Setup for the Azure-SSIS Integration Runtime
In this tip we will look some of those additional configuration steps when using the Azure-SSIS Integration Runtime (IR) which allows you to lift and shift your existing SSIS projects to the Azure cloud.
Execute SSIS Package in Azure-SSIS Integration Runtime
In this tip we will explain how you can deploy, execute and schedule SSIS packages in the Azure cloud.