In-Memory Import vs Direct Query: What you need to know when loading data

Hello everyone, I hope y’all are having or will have a great day today. In this blog post I will be covering the differences between In-Memory Import and DirectQuery from its effects on the front-end (your report and DAX) as well as the effects on the back-end (Power Query Editor and loading data processes). Without […]

Pass Parent Package Values to Child Packages via Parameter Binding

Introduction                I was working on a project that required passing of variable values obtained from a parent package query to the child packages and want to share with you how I was able to achieve this. For my project, I had to get the latest date from the Insert Date column and calculate the […]

Importing Web Data into Power BI

Hello everyone, it has been a while since I have posted any blogs. I am going to hop back into it with a simple one where I will show how to do an ETL Process on Web Data using Power BI. Here is a link if you would like to follow along: https://www.msn.com/en-us/money/watchlist?id=a1sj9c&tab=TopGainers. First up […]