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

[Ismail94]

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!

[amitchandak]

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

use as suggested

pip install xlrd

or

conda install xlrd

[Ismail94]

I have already installed 2.0.1 version of xlrd but not working