Problem: Data Factory V2 -> Azure Blob Store -> Azure SQL DW Polybase -> Azure SQL DW
-> Power BI.

plan:

• config variables

• create blob store

• configure local files

• create pipeline from local to blob

• execute pipeline to import data from local to blob staging

• create DW

• create external tables

• execute polybase import to DW

• create pbi template in direct query mode

• all scripted.

• tear down resource group

Learnings: ARM templates