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
Ismail94
Frequent Visitor

Trying to import xlsx file via python script to POWER BI but it shows Error

Hi!  I am trying to import xlsx file via python script but it shows

 "Details: "ADO.NET: Python script error.
<pi>ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.
</pi>""

 

You may say why i am not importing directly to power bi, the issue is i have a large dataset which i am trying to make pivot table by using lookup formula of python. To do the look up i need to import xlsx file and then squeeze it via pivot_table. 

You also may say that i need to only install xlrd library to python but this one also already installed and when i write a script "import xlrd" it shows :

Details: "ADO.NET: Python script error.
<pi>ModuleNotFoundError: No module named 'xlrd'
</pi>"

 

Could someone help with this issue please, I would really appreciate it in advance!

2 REPLIES 2
amitchandak
Super User
Super User

@Ismail94 , it seems it not installed or not the proper version

 

use as suggested

pip install xlrd

 

or

 

conda install xlrd

I have already installed 2.0.1 version of xlrd but not working

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.