Level: Beginners I help a lot of people on forums who ask questions about time intelligence for DAX. If you are just starting out then the chances are that you may not even be clear what time intelligence is and hence sometimes you don’t even know what to ask. Often […]
Level: Intermediate Last week I shared how it was possible to easily create an online survey using Excel for O365. Once such a survey is created, the data can be imported into PowerBI.com and used to create a simple report. The biggest issue with directly connecting to OneDrive like I showed […]
Level: Beginners I think today’s article will be of interest to my readers even though it is a little astray from my normally pure Power BI, Power Pivot and Power Query content. I will show you how to quickly and easily create an On-Line Survey that you can distribute to […]
Edit Feb 2017: I am very excited to discover that download report now works as I would expect. This blog post was going to be about how excited I was to hear that there is now an option to download a PBIX file from the Power BI Service to your […]
Level: Beginners If you want to learn new skills using a new tool, then you simply must practice. One great way to practice is to weave the new tool into you daily problem solving. If you have something meaningful to do with the new tool, then you are much more […]
Level: Beginners One of the great challenges Microsoft has faced with its “new” suite of Self Service BI tools (particularly Power Pivot) is that most people that could benefit from the holy trinity (Power Pivot, Power Query and Power BI) don’t even know these tools exist, let alone how the tools […]
Level: Beginners Edit: Sep 2019 I really love Power BI, and I have learnt so much over the last 12 months that sometimes it is easy to forget the challenges I had in getting started. Today I am sharing my top 10 tips on how to get started with Power […]
One year ago today on the 24th July 2015 a brand spanking new BI baby was born. And its proud parents named the new baby Power BI, and soon Power BI would become known to everyone around the world. Today is therefore a day to celebrate what a great first […]
Level: Intermediate Update: 2019. You can now do this natively in a Matrix, but this is still a good trick that can be used to solve various problems. You may or may not be aware that it (previously was) not possible to put Measures on rows in a Matrix in […]
Level: Beginners Today Microsoft announced a great new feature that allows you to direct connect FROM Excel TO Power BI and not the other way around. This simple change really streamlines the integration experience between Excel and the Power BI Service, and makes Power BI even more like you own […]
Level: Beginners I have learnt a lot about sharing Power BI content over the last year since Power BI hit the main stream. A lot of my learning has come from trial and error, and there are lots of things I wish I knew before I started. Today I am […]
I was super excited by the May 2016 Power BI Desktop update as it had a stack of great new features. Today I am covering the ones I think are the most useful. They are Conditional Formatting Nudge Objects on the canvas Quick Calcs Customisable ToolTips Improved CSV connector Conditional […]
Level: Intermediate One of the many excellent sessions I attend this week at the PASS Business Analytics Conference in San Jose was a session titled “Get Latest Insights by connecting your data using Power BI Content Packs and PBI Gateways”. The title was interesting but the content presented by Dimah Zaidalkilani […]
In October last year, Iman Eftekhari and I set up the Official Microsoft Power BI User Group (PUG) here in Sydney Australia. Since then we have gone from strength to strength and as of the time of this post the user group consists of a total of 330 members. If […]
Level: Beginners Edit: Sep 2019 What is Power BI? Microsoft Power BI Expert, Matt Allington, explains This ‘What is Power BI’ post is the third in my “what is” series having previously blogged about “What is Power Pivot” and “What is Power Query”. This topic is the hardest of the […]
Microsoft announced another awesome Power BI feature recently. This Power BI Analyze in Excel feature was requested by Avi Singh from PowerPivotPro.com and was heavily supported as a requirement by the community. You can read more about how you can influence future releases at the bottom of this post. But […]
Level: Beginners It is now possible to share your (public) reports from PowerBI.com with anyone over the internet for free (currently a free preview), without the need to manage licencing, logins etc (see demo below). Microsoft has been promising this feature for a couple of months now and the speed […]
In a recent release of Power BI, I was really excited to see that the team had created the ability to pin an Excel workbook to a Power BI Dashboard. I have been waiting for this and it was high on my list of things I missed most versus SharePoint Enterprise. However […]
The team at Power BI is setting a blistering pace of updates and improvements for PowerBI.com and Power BI Desktop. One of the great improvements in the November 2015 update is the ability to control how cross filtering between charts (and other objects) on the canvas works. The default cross […]
I just finished watching the presentation from James Phillips – GM of Power BI at Microsoft from PASS Summit 2015. He talks about the incredible progress that Microsoft has made this year in the BI space, particularly with Power BI, but importantly about the future of Business Intelligence at Microsoft. […]
Excelerator BI | © 2023 | Sitemap