PivotTables created with Power BI using Analyze In Excel should work after publishing to Power BI
Power BI's Analyze in Excel functionality allows Excel users on the desktop to create reports using PivotTables and cube formulas connected to a published Power BI dataset. However (and this is very hard to explain to customers) these reports only work on the desktop: even though Power BI allows you to publish Excel workbooks to an App Workspace, reports created using Analyze In Excel do not work after they have been published to Power BI because Excel Online does not support connections to Power BI. Please fix this!
PLEEAASE make it possible!!
Also by making Power BI Reports based on SSAS Tabular with live connection --> After Publishing in PBI Service it should work.
Yes... please please please fix/enable this. This just makes sense to complete the Excel analytics story.
I used this report and had many problems with it, thank you for your sharing.
Visit my blog if possible
Donald Parish commented
And could make work for Azure Analysis Services connections as well.
Nguyen Thu Hien (JellyFish) commented
Thank you for sharing, the comments are great
here my website: https://sosanhthoi.com
oted - this would be great!
My website: https://shopdaphongthuy.net
Do Bao commented
Good point :D
Paul O'Sullivan commented
This feature would make a massive difference to Excel enabling huge efficiencies for large organisations with multiple spreadsheets needed regular updates. Please Microsoft at least update us as to your plans around this feature.
Stelvio Gori commented
The Power BI team is doing a great job listening to users requests, answering, and incorporating them in the development roadmap, why does this does not happen with other MS teams?
This is a killer feature, up to the Excel team according to the PBI team, it's unbelievable we don't get any answer!
Can someone from Microsoft please provide an update on this? Is this being considered/planned? Thanks in advance!
Excel online Forms cannot automatically calculate the form after writing data, only manual recalculation can be performed. This BUG only happened this month, which was not found before.
Michelle Schnabel commented
There is a related idea on the Power BI side that doesn't have very many votes. Find it here:
Our company has an open ticket with MS support on this.
We have our PBI reports linked to SSAS tabular and in this scenario there could be the possibility, according to MS support, to make the "Analyze in Excel" file work by granting HTTP Access to Analysis Services on IIS 8.0
Has anyone tried this solution?
We are configuring the server following the instructions in the link above; I'll let you know if it works..
Good point :)
Well Tim they ARE slower than pivots, and in large volumes yes you will notice a problem.
Still though, in most cases you should be ok. (Also, once we get this enabled, we can THEN complain about any perf problems, so let's keep the upvotes and enthusiasm coming!)
Rob, I love cube formulas too, but I was nervous about using them in large volumes after talking with Per Solli about it. Sounds like maybe you've used them heavily against cloud models without experiencing too much pain?
Geoff Fawcett commented
Definitely Cube Formulas. That is very high value because there are so many reports out there built in a specific Excel format that managers/exec's want to keep seeing in that exact format. This would enable that to work, but supported by a PBI/AS data source.
Nah Tim, cube formulas ARE batched, just not as efficiently as pivots.
Don't CUBE FORMULAS have a problem though in that each one individually makes a call to the cloud model which is a pretty big performance problem?
Not to mention - CUBE FORMULAS! The one visualization type that basically no competing tool (nor Power Bi itself) can ever really replicate. Cube formulas against cloud models (PBIX, SSAS Tabular, etc.) are a killer app.