by Melissa Coates | May 21, 2017 | SQL Chick
I’m a big fan of reusing Power BI datasets whenever possible to minimize redundant datasets floating around the organization. It’s less maintenance, less chance of calculation differences, and less data refreshes to schedule. Info verified as of: May 20,...
by Gil Raviv | May 19, 2017 | Data Chant
Follow Me As promised here, today we will web-scrap Office Store website, and extract the information to build a catalog of Power BI Custom Visuals. You can share this tutorial with colleagues, and use it as an exercise to improve your Power BI skills. Another great...
by Reid Havens | May 18, 2017 | PowerPivotPro
Data IS Life…and “Life, Uh, Finds A Way.” P3 friends…for those of you in the know (and for those who aren’t), Power Query (or PQ for short) is one of the cornerstones of the Microsoft BI Suite. It’s a tool… The post Power Query (M)agic Part 1: Always Have Good...
by Chris Webb | May 17, 2017 | Chris Webb
If you are using SSAS Multidimensional and you use Process Update to process your dimensions, here’s something for you to try: run a Process Default on your cube. Does it finish in a few seconds? Then you’re ok. If it doesn’t, and it takes minutes or even longer then...
by Rob Collie | May 16, 2017 | PowerPivotPro
In First Impressions, Power Query Steals the Show Let’s say I have ten minutes with an “uninitiated” Excel pro – someone who slings VLOOKUP and Pivots all the time, but has no idea that Power Pivot and Power Query exist. … The post M/Power Query “Sets Up” DAX, so...