topic Re: Python script in Power BI transform data/power query returns date as Microsoft.OleDb.Date in DAX Commands and Tips

Python script in Power BI transform data/power query returns date as Microsoft.OleDb.Date

ironboy0423 — Sun, 30 Jul 2023 12:05:02 GMT

Hi, guys.

I am having issues when I use python script in transforming data. The date became unreadable? or Microsoft.OleDb.Date. May I know the most effective way to fix it? Here's my python script:

import pandas as pd dataset = pd.DataFrame(data=data) dataset['Supplier Name'] = dataset['Name'].str.replace(r'^.*-\s*', '').str.strip() dataset.drop(columns=['Name'], inplace=True) dataset.reset_index(drop=True, inplace=True)

Re: Python script in Power BI transform data/power query returns date as Microsoft.OleDb.Date

ironboy0423 — Sun, 30 Jul 2023 22:02:37 GMT

Please consider this as resolved. I just did the step for changed type with local after running the python script:

Re: Python script in Power BI transform data/power query returns date as Microsoft.OleDb.Date

Yogesh_BI — Tue, 22 Apr 2025 12:27:13 GMT

Hi,
Facing similar issue in python script in Power query. where is option to change the type Locale?

Thank you !!