October 21, 2018

Types and Folding within Power Query

This appears to have changed since I posted this and now it will query fold when types are changed in either manner.

I recently found this trick to improve folded queries when changing data types. It allows you to do type changes of columns without breaking the query folding. You can see if a step has been folded by right clicking on the step, if “View Native Query” is an option then the step has been folded. (Note that the opposite is not necessarily true, some sources do support some query folding yet do not allow you to see/edit the native queries.)

October 13, 2018

I passed the Microsoft 70-778 Exam (Power BI Exam)!

So I just took the 70-778 exam online, and I passed! I obviously can’t say what was on the exam but I will say a few thoughts I had about the preparation for and process of doing the exam itself.

In terms of preparation 80-90% of what prepared me was my experience with the Power BI. This isn’t a quick way to learn but it is the best and there is no substitute for it. I did buy the accompanying book by Daniil Maslyuk, which did help for some of the areas I wasn’t very experienced with. For example loading excel workbooks into the service or the administrative side of Power BI. The final piece of preparation that I found useful is a quiz that was made by Rishi Sapra. It has similar questions to what the exam contains. It is a bit out of date now, but it is still worth doing at least once.

October 6, 2018

TFL cycling data Power BI Report

This Power BI Report was created for the fourth London Power BI User Group [PUG] challenge. This is the second time I have done this challenge but the first I feel I have been pleased with my submission

If you are interested in Power BI I would really recommend going to a PUG. It is great to meet and learn from people who have a similar passion. If you come to the London PUG, take part in the challenges! They are every other month so you have two months to work on the challenge. They get announced at the user groups but also on Prathy’s blog.
The next London PUG is on October 23rd with Susie Bentley, hopefully I will see you there!