This is a listing of my favorite tools and learning resources.
Power Query / M
Book: Chris Webb, Ken Puls
Blogs: Chris Webb, Ken Puls
Documentation: Microsoft’s Documentation, Power Query’s built in documentation
Writing M: NotePad++ M Language
PowerPivot / DAX
Book: Rob Collie, Matt Allington
Video: Rob Collie
Blogs: Rob Collie, Matt Allington, SQLBI.com
Helpful Add-ins: DAX Studio, DAX Documenter
Video Playlist: Highlighting several features of the Power BI Desktop and the Power BI Service
Power Update provides automated refresh for Power Query and PowerPivot, and can push data to the Power BI Service through OneDrive.
Books: Excel Data Analysis and Business Modeling, Data Smart