gowheyaAug 121 minWrite 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 minSQL 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 minPower 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...