cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
masari23
Helper I
Helper I

The exception was raised by the IDataReader interface.Issue with refresh on Services.

Hi,

 

I have a Power BI report which has around 8-10 csv files. It used to refresh perfectly fine on services but from few days it always keeps failing with this error:Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: SendTechTrend_2020.Cluster URI:WABI-US-EAST2-redirect.analysis.windows.netActivity ID:173fbc3f-3c8f-41ae-bb34-3185be023bc6Request ID:2592f9d7-57ca-4a0b-c1f5-dac7b7c2e963Time:2021-03-15 10:35:32Z

 

 

So, I searched a bit on the blog and found out that it has something to do with encoding of the csv files, that if we convert to 65001(UTF-8) this error goes away. Intially the encoding in my report was set to 1252, so I changed the encoding to 65001 and re published the report. But still the same error keeps on coming.

 

Does someone know the work around for this?

 

Regards,

Manisha.

1 REPLY 1
v-caitlyn-mstf
Community Support
Community Support

Hi@masari23 ,

 

Please check if it is caused by the following reasons :

1.Mismatch between the data types of the keys used in relationships.
2.Improper date formats of the date fields in relationships.
3.(null) values in columns with decimal/whole number data types

 

Make sure the data types of both the fields in a relationship are same. replace (null) values with 0 for decimal or whole number data types.

 

For more information,you can refer to this :Error-the-exception-was-raised-by-idatareader-interface/ 

 

If it doesn't work, please let me know.

 

Hope it helps.

 

Best Regards,
Caitlyn Yan

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors