Forum Discussion

Advocate II

9 years ago

Data Source Error

Hi All, I am getting this error while doing refresh to the database can any one please help me out Thanks, Pratima

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

Anonymous

Not applicable

9 years ago

Do you connect to SQL Server database in Power BI Desktop? Could you please post the full error message for us to analyze?

Thanks,
Lydia Zhang

Advocate II

9 years ago

Hi All,

I am trying to connect to the Excel Sheet ,in that file updated the data into that

Thanks,

Pratima

Thanks,

Pratima

Anonymous
Not applicable
9 years ago
Hi Pratima,

Please go to Query Editor to check if you have any steps that change from original data types, remove these steps and see if the error goes away. You can take a look at the following similar thread to get details.

http://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DISP-E-TYPEMISMATCH/m-p/33267/highlight/true#M11764

Thanks,
Lydia Zhang
Pratima
Advocate II
9 years ago
After deleting the Change types again am getting error like this....................
Can any one plz help me out....................
- Anonymous
  Not applicable
  9 years ago
  Hi Pratima,
  
  Add Value() function in your SWITCH dax formula to convert your text string to number.
  
  If the issue still occurs, please help to share PBIX file and original Excel file.
  
  Thanks,
  Lydia Zhang

Related content