Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
chi_nomad
New Member

Power BI in Excel

Am in the process of learning Power BI and am going through the Microsoft Learn paths.  I am having trouble with Excel 2021 showing Power BI as an option.  Have tried Inserting PivotTable but Power BI isn’t showing up.  Also tried the “Get data” option.  Again Power BI is not showing.   Have the Power Map and Power Pivot add-ins enabled but not the Publisher one as it isn’t an option.  Have made sure the most recent updates for Microsoft Office are done.  Any advice with this?

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

I think you can import the DAX measures which you have written in PowerBI Desktop into MS Excel only when you publish the PBI Desktop file to the PowerBI service.  Furthermore, i think you need to have a certain subscription type to get data from PowerBI into MS Excel. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

I think you can import the DAX measures which you have written in PowerBI Desktop into MS Excel only when you publish the PBI Desktop file to the PowerBI service.  Furthermore, i think you need to have a certain subscription type to get data from PowerBI into MS Excel. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Nathaniel_C
Super User
Super User

Hi @chi_nomad ,

 

I have 365 v 2205. See this picture.

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 

Nathaniel_C_0-1656800563702.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.