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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
FilipFireFlyBI
Resolver I
Resolver I

SKlearn not working in PowerBI Desktop

Hi all,

 

I try to import this Python code that works properly in Spyder (Python 3.7):

See this YouTube video: https://www.youtube.com/watch?v=0zveIwThlfE&t=145s (watch from 6:00min).

 

Spyder_Python_code.PNG

However, when I copy this code to PowerBI I get this error message:

PowerBI_error_SKLEARN.PNG

 

My machine CMD tells me this:

CMD.PNG

Important to note: In Power BI I use the Python home directory as indicated in CMD. When I use Python code with only Panda's, Numpy or Matplotlib there are no issues at all in my Power BI Desktop.

 

Any idea what is wrong / how to solve?

Thanks in advance!!

6 REPLIES 6
nuwanhwb
Frequent Visitor

Hi,

Try the below . It may help
Use "conda install scikit-learn" instead of conda install sklearn

FilipFireFlyBI
Resolver I
Resolver I

Hi all,

 

I have tried to get this working (back in 2019). What I can remember is that this finally did not work.

I have not tried other options anymore.

 

Regards,

Filip

nirvanamike
Regular Visitor

@FilipFireFlyBI have you found a solution to this? I am stuck as well. Everything works well besides the sklearn import. The above didnt work for me either.

I am also stuck in this as well. Are there any option

v-lionel-msft
Community Support
Community Support

Hi @FilipFireFlyBI ,

Please modify your code like this and try again.

components = pd.DataFrame(list(zip(x.columns, coef)), columns = ['component', 'value']) 

If it still doesn't work, please check your user environment variables:
e1.PNG
 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lionel Chen,


Thanks for reply but both options did not work for me.

 

Regards,

Filip

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors