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:
@Ko_Ver @diverdown1964 Yes, only SSAS Tabular is supported for live connections
— Christopher Webb (@Technitrain) July 14, 2015
And some more:
@Ko_Ver @Technitrain – You need a license for on-prem refresh of any kind… only cloud sources are supported for the free version — John White (@diverdown1964) July 14, 2015
And even more:
@Ko_Ver @Technitrain – That means “Go get the data model, Power Queries, and Power views”. U can refresh for free if they are cloud sources
— John White (@diverdown1964) July 14, 2015
The general conclusion:
@Ko_Ver @diverdown1964 I think we all feel like that. I made that point to @idigdata the other day… — Christopher Webb (@Technitrain) July 14, 2015
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 🙂
------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
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!