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...
gowheyaMar 13, 20231 minWhich data modelling framework should you use?How to determine which data modelling framework to use in your project There are currently 3 main data model frameworks available in...