Just a quick post on some Power BI material that I believe should reach as many people as possible. I get the notion there is a lot of confusion about what is possible in Power BI v2 and which features are supported in the free and in the paying version. (I gave a session on Power BI to make it less confusing, but I primarily talked about all the different Power BI Excel add-ins and their capabilities.) What’s particularly hard to follow is the data refresh / live connections / personal gateway / data management gateway scenarios.
Luckily John White (blog | twitter) wrote an excellent overview: The New Power BI Personal Gateway – Do I Need It?. His blog post details what you can do with the personal gateway and the (older) data management gateway. Recommended reading!
After reading the article, I had some follow-up questions:
And some more:
And even more:
The general conclusion:
If you have the time, read the entire Twitter conversation; it’s really interesting. We were talking about this, to be precise:
My point of this post? There is a lot of confusion about Power BI and its capabilities out there. If you’re confused as well, you’re not alone!
ps: this doesn’t mean Power BI is an awful product though. Just the documentation 🙂
I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…
You can find the slides for the session Building the €100 data warehouse with the…
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…
View Comments
Hi Koen,
Do you know if Excel pivot tables are supported in v2? I definitely want to move our own company reports to v2, and also those of a client of mine, but Power View isn't enough. Most high detail reports just need pivot tables.
Would like your thoughts on this.
Bas
Hi Bas,
I believe Power BI will support Excel Online functionality soon.
More info:
Announcing Power BI general availability coming July 24th
Look for the paragraph "Team collaboration and enhanced Excel support".
This could not possibly have been more helpful!