Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
Iám trying to implement machine learning in power BI , While trying to run the python code at edit queries level , the below given error is being thrown , can anyone guide me with a possible solution :
Python code :
from pycaret.clustering import *
dataset = get_clusters(data = dataset)
Error generated:
DataSource.Error: ADO.NET: Python script error.
Traceback (most recent call last):
File "PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib
File "C:\Users\subhashreer\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\__init__.py", line 55, in <module>
from pandas.core.api import (
File "C:\Users\subhashreer\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\api.py", line 29, in <module>
from pandas.core.groupby import Grouper, NamedAgg
File "C:\Users\subhashreer\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\groupby\__init__.py", line 1, in <module>
from pandas.core.groupby.generic import DataFrameGroupBy, NamedAgg, SeriesGroupBy
Hi. This might sound a stupid question but, is this code working outsite Power Bi? As far as I remember you have to specify the number of clusters.
I have found these articles. I hope they can help you:
https://towardsdatascience.com/how-to-implement-clustering-in-power-bi-using-pycaret-4b5e34b1405b
https://prog.world/how-to-implement-clustering-in-power-bi-using-pycaret/
Regards,
Happy to help!
Hello @Anonymous,
The cluster number need not be specified because in the standard function, the cluster number is taken as four. There is a problem somewhere else.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
67 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |