Text Analytics using Machine Learning Python Script in PowerBI

[arun2001mjl]

Hello All,

I have a 2 sets of Raw Data as Training Data and Test Data.

In PowerBI... I have uploaded a Raw Data with the File Name "Training Data" with the following Columns:

Ticket Number, Status, Short Description, Category, Open Date, Resolved Date.

Category was created manually based on Short Description Column.

Ticket Number	Status	Short Description	Category(Manually Updated)	Open Date	Resolved Date
Ticket 1	Open	User Account Locked	Account Unlock	12-Apr-22	12-May-22
Ticket 2	Resolved	User Need Password Reset	Password Reset	12-Apr-22	12-May-22
Ticket 3	Resolved	Server AAA Down several times	Server Restart	12-Apr-22	12-May-22
Ticket 4	Resolved	Please Unlock user account	Account Unlock	12-Apr-22	12-May-22
Ticket 5	Resolved	Reset VPN pin	Reset Pin	12-Apr-22	12-May-22

Every month, to avoid doing this Manually.. I need to Train the old data and bring this Category in new set of data which will be uploaded in PowerBI.

Can we Train the old model and update the Category in new data in Powerbi using Machine learning/Python Scrips. 

If anybody has Sample PBI file, pls share it or please advise on above.

Regards

Arun

[annlois]

hi, did you find a solution for this? I have the same problem

Thanks

[arun2001mjl]

Hello,

Still i did not find the solution for that.

Thanks

[amitchandak]

@arun2001mjl , Have you tested if your model can work while importing data using python?

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts

How to make Python work with Power BI: https://youtu.be/5D0BkNsu5CM