gowheyaAug 121 min readWrite to destination error On Dataflow Gen2 with On-premise Data gateway(OPDG)An important consideration for Dataflow Gen2 used for ETL with OPDG is your network firewall settings. When you read data from on...
gowheyaJul 12, 20231 min readSQL Scripts equivalent in M-Language for Power Query1. Table rows Partition in SQL using window functions SELECT FirstName, LastName, City, ROW_NUMBER() OVER ( PARTITION BY City ORDER BY...
gowheyaMar 13, 20231 min readPower BI dataflows and Azure Data factory [ADF] dataflows: the same thing or different?While it is true that both Power BI dataflows and Azure Data factory (ADF) performs similar ETL functions and are both powered by Power...