"ADO.NET: Unable to find the requested .Net Framework Data Provider. It may not be installed."

Hi everyone, 

I'm having some this error below while trying to use python script to learn pkl machine learning models within power bi:

I was re-install the microsoft .net framework with the latest version and also try to find any duplicated values within model.config file but there is none..

This below is my python scripts to enable it..

Do you know how to solve this issue? Thanks!

import pandas as pd
import pickle
from datetime import timedelta

# Load the model
with open("C:\Users\Downloads\hospital_los_model.pkl", "rb") as file:
model = pickle.load(file)

# Example test data (in production, pull this from a database or file)
test_data = pd.DataFrame({
'Age': [90],
'Gender': ['F'],
'Admission Date': [pd.Timestamp("2024-11-23 13:32:00")],
'Number of transfers': [2],
'Current ward': ['WARD7'],
# Add any other features your model expects
})

# Assume model has a predict method that returns LOS
predicted_los = model.predict(test_data)

# Add predictions to the DataFrame
test_data['Predicted LOS'] = predicted_los
test_data['Predicted Discharge'] = test_data['Admission Date'] + test_data['Predicted LOS'].apply(lambda x: timedelta(days=x))

# Output for Power BI
output = test_data[['Age', 'Gender', 'Admission Date', 'Number of transfers', 'Current ward', 'Predicted LOS', 'Predicted Discharge']]