Power BI Tips

https://www.fourmoo.com/2020/10/08/power-query-m-passing-parameters-dynamically-to-a-sql-server-query/  

https://exceleratorbi.com.au/use-power-query-compare-database-records/  

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview  

https://www.fourmoo.com/2020/06/10/how-you-can-incrementally-refresh-any-power-bi-data-source-this-example-is-a-csv-file/  

https://www.fourmoo.com/2020/07/01/how-to-configure-incremental-refresh-with-power-query-in-power-bi/  

https://www.youtube.com/watch?v=kjeR7nZ3Clw  

  https://docs.microsoft.com/en-us/powerquery-m/

  https://www.youtube.com/watch?v=WN1cvJGutT8

https://www.youtube.com/watch?v=-x2dLTtKiR8  

https://www.youtube.com/watch?v=lDjKS3Ur3ks  

https://www.youtube.com/watch?v=r3B2mcewXSE   https://radacad.com/know-your-data-better-by-column-profiling-in-power-bi-using-power-query Go to the View tab in Power Query and enable Column quality, column distribution, and column profile. Check bottom right to choose column profiling based on sample of all rows.

  https://www.mssqltips.com/sqlservertip/5998/getting-started-with-power-bi-and-power-query-for-simple-etl--part-2/

  https://radacad.com/row-filtering-in-power-bi-and-power-query-remove-blank-rows-vs-remove-empty

Power Query: New Source, Blank Query, Advanced Editor Copy the following code into the Advanced Editor: let     Source = DateTime.LocalNow(),     #"Converted to Table" = #table(1, {{Source}}),     #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "DateTime"}}),     #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"DateTime", type datetime}}) in     #"Changed Type"