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'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…
I wrote a piece of SQL that had some new T-SQL syntax in it: IS…
I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…
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!