Forum Discussion
Power BI Publisher for Excel Retired?
chammel
This meassage is confirmed by our team, as of April 1st, 2020, users will not be able to download the Power BI publisher for Excel. Microsoft will cease its support for the tool on June 1st.The publisher for Excel included the following functionalities:
- Allow users to connect to their data in Power BI and create pivot tables and charts for further analysis in Excel
- Allow to pin a selected range in an Excel sheet to a Power BI dashboard
Alternatives
As an alternative to functionality 1, users can launch the ‘Analyze in Excel’ function from within Power BI service.
As an alternative to functionality 2, user can either Pin a tile to a Power BI dashboard from Excel or capture a selected range in an Excel sheet, using any clipping tool -> open the target dashboard in Power BI.com -> click ‘Add tile’ -> chose ‘image option’ -> upload the captured image.
Paul ZhengCommunity Support Team
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Yep, That's obvious.
But not a great experience compared to being able to connect to your Power BI Datasets straight from excel!!!!
You can connect directly to a dataset.
You have to go now to Data/Get Data/From PowerBI Dataset
Thanks for the info,
So if your not part of this insider channel then you can't use the Get Data > From Power BI Dataset.
At the moment we are stuck with a poor work around in Analyse in Excel, and waiting for this feature to be released some time this year.... and no mention of when from Microsoft.
Why get rid of the Power BI Ribbon in excel when there is no other option available for replacement.
Microsoft????
That doesn't appear to be the case from my testing.
If users are on Microsoft 365 with E5 Agreement will they be able to use the Get Data > From Power BI Dataset
feature in excel.
Or is this still not available.
I am using version 2005 as documented here. But under Data > Get Data, I do not see an option to get data from a Power BI Dataset. What is going on?
You need Version 2006 (Build 13001.20198)
Can you?
When is this feature available and on which version of excel?
I don't see it with M365 or Excel 2016
Excel Version 2006 (Build 13001.20198)
I put another computer on the Monthy (Targeted) channel, I reinstalled again the PowerBi Excel extension and got the Connect PowerBI item.
Yep... Same issue... option not available in O365.
Not sure what you mean by build version or why we need to re-install Excel.
Why isn't Microsoft update documentation and posts about this!!!!!
You need to have the beta version.
You need to change your office update policy
https://windowstechpro.com/switch-office-365-semi-channel-to-monthly-targeted-channel/
But be careful with beta comes the last features but also the last bugs!
Anonymous i'm on Current Channel aka Monthly Channel accoring to my understanding, and I have an E3 license. I am not getting 2006.....
Edit: I see it's only in the Insider channel.
