Data refresh error: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.

I received a similar error upon refresh of my Power BI dataset when it was working fine in the past.  

I found a workaround as follows:

1. Use the Transform Data option from the Power BI desktop Home menu.

2. Click on your query that is producing the OLE DB/ODBC Error and select the Advanced Editor menu option.

3. Save a copy of your original logic that appears in the Advance Editor by copy/paste to Wordpad.

4. Comment out or remove a large portion of your query logic so that you leave a cutback version and click "Done" from within Advanced Editor to save the revisions.

5. Exit the Transform Data area by choosing the "Close and Apply" option.   

6. Your query will attempt to reload for the data refresh.  Determine if it is successful. If not then you need to keep commenting out the logic in it until you can get it to run successfully. 

7. Once you get the query to run successfully for your data refresh, go back into the "Transform Data" area and the Advanced Editor option and add back into the query the original logic, save and exit with the "Close and Apply" 

8. After performing the above steps, my original logic for the data refresh ran perfectly and the OLE/ODBC error disappeared. 

I realize this is an odd set of steps but it worked for me and had the least impact on my PBIX.