Azure Data Factory – Copy files from SharePoint to Azure Data Lake Storage When you need to copy files from SharePoint to the Azure Data Lake, you’ll find yourself in a more difficult position than you might expect. Even though SharePoint is Microsoft, smooth integration isn’t just the case. But don’t be afraid, it will…
Author: Hylke Peek
Add user (AAD) to the Azure SQL Database
Add user (AAD) to the Azure SQL Database It’s a simple task: ‘Add the user to the database’. But when you’re used to on-premise environments, you have to think a little bit differently. It’s still simple, but different. The big difference is the concept of contained databases where you don’t map users to a (server)login….
Use Azure Pipelines for automated deployment of Power BI files
Use Azure Pipelines for automated deployment of Power BI files During the development of BI-solutions most of the sources are well maintained: central source location, version control, tracking changes, and automated deployment. Yes, not everything. Most of the time data pipelines, database(s), and analysis service model(s) are controlled with a service like Azure DevOps. Power…
Use Release Pipelines for automated deployment of Power BI files
Use Release Pipelines for automated deployment of Power BI files During the development of BI-solutions most of the sources are well maintained: central source location, version control, tracking changes, and automated deployment. Yes, not everything. Most of the time data pipelines, database(s), and analysis service model(s) are controlled with a service like Azure DevOps. Power…
Use Power BI Rest API to deploy Power BI files
Use Power BI Rest API to deploy Power BI files During the development of BI-solutions most of the sources are well maintained: central source location, version control, tracking changes, and automated deployment. Yes, not everything. Most of the time data pipelines, database(s), and analysis service model(s) are controlled with a service like Azure DevOps. Power…
Configure access to Power BI Rest API
Configure access to Power BI Rest API Before you can use the Power BI Rest API, you need to configure a few things. In this blog, I’ll explain the exact steps you need to take before using the API. There are 4 steps: Create a Service Principal (SPN) in Azure Portal Add Security Group Configure…
Power BI version control with Azure DevOps
Power BI version control with Azure DevOps During the development of BI-solutions most of the sources are well maintained: central source location, version control, tracking changes, and automated deployment. Yes, not everything. Most of the time data pipelines, database(s), and analysis service model(s) are controlled with a service like Azure DevOps. Power BI models and…