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 🙂
You can find all the session materials for the presentation "Indexing for Dummies" that was…
The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…
You can find the slides of my session on the €100 DWH in Azure on…
I've used Logic Apps a couple of times over the past years for simple workflows,…
I'm giving two online sessions soon on virtual events that are free to attend. The…
I wanted to try out the new JSON index which is for the moment only…
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!