Solved: Can't Get Power BI Add-In For Excel

Maxwell · ‎07-21-2020

After going to Power BI Service, I hit the '...' then 'Download' then 'Analyze in Excel Updates'. I get a file named "x64_15.0.2000.443_SQL_AS_OLEDB". After installing I can't find the power bi add-in in excel. I've check Excel Add-ins, COM Add-ins, and Disbaled Items. Does anybody know how to fix this issue? I have the 64 bit version of excel. I have micrsoft Office E5. Both Excel and Power BI Are up to date. Any help appreciated!

parry2k · ‎07-21-2020

@Maxwell I think you are referring to Power BI publisher which is not available any more (afaik), check this post for analyze in excel

Again, you are using E5 license, you are better of connect to Power BI dataset directly from Excel.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎07-21-2020

@Maxwell if you have E5 license, you can directly connect with Power BI dataset in Excel instead of using Analyze in Excel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Maxwell · ‎07-21-2020

I still want the Power BI tab to show up in excel

parry2k · ‎07-21-2020

@Maxwell there is not tab, it just connect to the model and you get pivot dataset in excel.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Maxwell · ‎07-21-2020

Oh I know some people they have a tab in excel called "Power BI". What is that than?

parry2k · ‎07-21-2020