Forum Discussion

samithc's avatar
samithc
Frequent Visitor
2 years ago
Solved

Error when trying to connect the Data Set using Python Script in Power BI

Hi    When i am trying to use python script to connect the Data set in Power BI. i am getting the below error. Python script was for getting data from Kaggle using Kaggle API.    Details: "An err...
Need Help
  • samithc's avatar
    samithc
    2 years ago

    Hi All, 

     

    i have found the solution for error. i was trying many things. Atlast I went to the C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config and edited the machine.config. 

    in that file MySql.Data.MySqlClient was there 2 times. I have removed the duplicate and now I am able to run the python script. 

    Thank you all for the response. 

     

    Reagrds, 

     

    Samith 

Walter726Herrin's avatar
Walter726Herrin
New Member
2 years ago

Hi Samith,

The errors in Power BI might be due to uninitialized objects or missing .NET Framework components. Ensure all objects in your Python script are properly initialized and check for null values. Also, verify that the necessary .NET Framework Data Provider is installed. Updating Power BI and checking dependencies for your Python script and Kaggle API might help. If the issue persists, consider reinstalling the .NET Framework or checking Power BI community forums.

  • samithc's avatar
    samithc
    Frequent Visitor
    2 years ago

    Hi Walter726Herrin ,  

     

    Below python script i have tried in VS CODE and it is working in VS CODE. 

     

    import kaggle
    import os
    import pandas as pd

    # Set Kaggle API credentials directory
    os.environ['KAGGLE_CONFIG_DIR'] = 'C:/Users/samit/.kaggle'  

    # Specify the dataset identifier
    dataset = 'piterfm/paris-2024-olympic-summer-games'

    # Set the download path
    download_path = r'D:\SAMITH\Power BI\Paris 2024 Olympics Dashboard\Source'

    # Remove existing files in the folder to prevent duplicates or outdated files
    for file in os.listdir(download_path):
        file_path = os.path.join(download_path, file)
        try:
            if os.path.isfile(file_path):
                os.unlink(file_path)  # Delete the file
                print(f"Deleted {file_path}")
        except Exception as e:
            print(f"Error deleting {file_path}: {e}")

    # Download the dataset using the Kaggle API and unzip the files
    kaggle.api.dataset_download_files(dataset, path=download_path, unzip=True)

    # List of CSV files to be imported
    csv_files = [
        'athletes.csv',
        'events.csv',
        'medallists.csv',
        'medals.csv',
        'medals_total.csv',
        'schedules.csv',
        'schedules_preliminary.csv',
        'teams.csv',
        'torch_route.csv',
        'venues.csv'
    ]

    # Initialize a dictionary to hold DataFrames
    dataframes = {}

    # Iterate through each CSV file and load it into a DataFrame
    for file in csv_files:
        # Construct the full path to the CSV file
        file_path = os.path.join(download_path, file)
       
        # Load the CSV file into a Pandas DataFrame
        df = pd.read_csv(file_path)
       
        # Add the DataFrame to the dictionary using the file name as the key
        table_name = file.split('.')[0]  # Remove the .csv extension
        dataframes[table_name] = df
     
    Also have tried installing .netframework 8. Not sure how to install  .NET Framework Data Provider. 
     
    Regards, 
     
    Samith