Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Adrien
New Member

DataSource.Error : OLE DB : Multiple-step OLE DB operation generated errors.

Hi,

 

This message appears when I try to refresh data in table:

 

DataSource.Error : OLE DB : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

ErrorCode=-2147217887

 

I have never had this problem before...

 

Can you help me?

 

Regards,

 

Adrien LEFEVRE

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft Employee
Microsoft Employee

Hi @Adrien,

 

For this error,  following are two possible causes of this error:

  • In the registry, under the key for an OLE DB provider's CLSID, there may be an entry named OLEDB_SERVICES. If the OLE DB provider that is used to make the ADO connection does not have the OLEDB_SERVICES entry, and ADO tries to set up a property that is not supported by the provider, the error occurs. For more information about this registry entry, see the "Resolution" section.
  • If OLEDB_SERVICES entry exists but there is a problem in the ADO connection string, the error occurs.

Please refer to the link below to see the details.

https://support.microsoft.com/en-in/help/269495/prb-multiple-step-ole-db-operation-generated-errors-...

 

Regards,

Charlie Liao

View solution in original post

3 REPLIES 3
armanfalah
Frequent Visitor

 

I had the same issue.

Power bi couldnt refresh the table because there were some string data in source and I wanted to load them into a integer column.

 

v-caliao-msft
Microsoft Employee
Microsoft Employee

Hi @Adrien,

 

For this error,  following are two possible causes of this error:

  • In the registry, under the key for an OLE DB provider's CLSID, there may be an entry named OLEDB_SERVICES. If the OLE DB provider that is used to make the ADO connection does not have the OLEDB_SERVICES entry, and ADO tries to set up a property that is not supported by the provider, the error occurs. For more information about this registry entry, see the "Resolution" section.
  • If OLEDB_SERVICES entry exists but there is a problem in the ADO connection string, the error occurs.

Please refer to the link below to see the details.

https://support.microsoft.com/en-in/help/269495/prb-multiple-step-ole-db-operation-generated-errors-...

 

Regards,

Charlie Liao

Hi Charlie,

 

The OLE DB provider I use to make the ADO connection dont' have the OLEDB_SERVICES entry...

I have added the OLEDB_SERVICES registry entry and it works.

 

Thank you for your answer.

 

Regards,

 

Adrien LEFEVRE

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.