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 🙂
Quite the title, so let me set the stage first. You have an Azure Data…
At Saturday the 21st of February I'm presenting an introduction to dimensional modelling at dataMinds…
I'm not trying to start up a debate whether you should use tabs or spaces…
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that's a…
Quite a long title for a short blog post :)While deploying a DACPAC (from a…
Yes, you're reading that right, we're going to download a report that cannot be downloaded.…
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!