Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: logic app

Reading AFAS REST API Data with Azure Logic Apps

February 26, 2023February 26, 2023 Koen Verbeeck Leave a comment

Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process is mostly the same as reading the data with Azure Data Factory (check out this blog post to learn more): There’s a minor difference in how […]

Read More

Build Once – Add Metadata (the importance of metadata-driven frameworks)

February 13, 2023February 20, 2023 Koen Verbeeck 4 Comments

When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I shout “STAR SCHEMA ALL THE THINGS” anywhere I can, because a star schema is the most optimal way to design your model in Power BI. We […]

Read More

Logic App errors out when using variables in a SharePoint Action

January 18, 2023January 18, 2023 Koen Verbeeck Leave a comment

I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to make this Logic App “generic”, meaning I could change the source folder and the destination container by using variables. That way, I have one single Logic […]

Read More

SharePoint List only returns 100 items in Azure Logic App

June 27, 2022June 27, 2022 Koen Verbeeck Leave a comment

I was reading a SharePoint List using the “Get Items” activity in an Azure Logic App. I explain how you can create such a Logic App in the blog post Reading a SharePoint List with Azure Logic App. It all worked fine for a while, but recently the list grew larger than 100 items. Suddenly, […]

Read More

Azure Function with PowerShell and the Power BI REST API

April 26, 2022April 26, 2022 Koen Verbeeck Leave a comment

In this blog post I’m going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as the programming language because in my opinion it was a bit easier to authenticate with the Power BI service. For the development environment, I’m using Visual […]

Read More

How to Deploy Azure Logic Apps with ARM and Azure Devops

April 21, 2022April 21, 2022 Koen Verbeeck Leave a comment

It’s easy to duplicate an Azure Logic App in a resource group, but unfortunately you cannot duplicate a Logic App between environments (you might try to copy paste the JSON though). So unless you want to hand craft every Logic App yourself on each of your environments, you need a way to automatically deploy your […]

Read More

Logic Apps and Source Control (with PowerShell)

April 20, 2022April 20, 2022 Koen Verbeeck Leave a comment

At a data warehouse project I’m using a couple of Logic Apps to do some lightweight data movements. For example: reading a SharePoint list and dumping the contents into a SQL Server table. Or reading CSV files from a OneDrive directory and putting them in Blob storage. Some of those things can be done in […]

Read More

Book Review – Pro Serverless Data Handling with Microsoft Azure

April 5, 2022April 5, 2022 Koen Verbeeck 2 Comments

Yet another book review! I just finished the book Pro Serverless Data Handling with Microsoft Azure: Architecting ETL and Data-Driven Applications in the Cloud (what a title :), written by German MVPs (and metalheads) Benjamin Kettner and Frank Geisler. The book handles the topic of “serverless” computing in the Microsoft Data Platform, where serverless is […]

Read More

Reading a SharePoint List with Azure Logic App

April 7, 2020April 7, 2020 Koen Verbeeck 3 Comments

Sometimes in life you have to do things you really don’t like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData source component for this task, as described in one of my most popular articles ever: Reading SharePoint Lists with Integration Services 2017 (I’m not kidding). However, […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements
  • How I passed the DP-700 Exam

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (112)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress