Data Source Error

[Pratima]

Hi All,

I am getting this error while doing refresh to the database can any one please help me out 

Thanks,

Pratima

[v-yuezhe-msft]

Hi @Pratima,

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

[Pratima]

Hi All,

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

Thanks,

Pratima 

Thanks,

Pratima

[Pratima]

After deleting the Change types again am getting error like this....................

Can any one plz help me out....................

[v-yuezhe-msft]

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

[v-yuezhe-msft]

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...

Thanks,
Lydia Zhang