IMPORT doesnot have Excel Workbook Contents option use student account

[Anonymous]

Hello All, 

I am using my student free account registered the PowerBI desktop. Just found out that there is no option"Excel Workbook Contents" in File - Import. Please see the screenshot below:

However, one of the Youtube teaching channels shows a different layout( which is what I want) :

Does that because I use the free student account? 

I would like to import my data model from Excel to Power BI, but what I have currently can not show the data model tables in the excel pivot table.

Any suggestions and ideas? thank you 

[amitchandak]

@Anonymous , Desktop edition has the same options.  This seems pretty strange. Create a new file and check the option. If you have chosen a live source in the file or used pbix as the source , it might not allow other sources.

Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy

Appreciate your Kudos.

[vivran22]

@Anonymous 

Use the last option: Power Query Power Pivot Power View

Power BI Desktop is free, and standard. With the latest version, the names have changed.

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

[Ashish_Mathur]

Hi,

Select the last item s seen in the first image.  This will import all data, relationships, DAX and M language formulas in the PBI Desktop file.