An unexpected error occured (file'pfoledbreader.cpp', line 836, function 'PFDBReaderOledb::Bind').

Anonymous Thank u for ur response.

Without giving out sensitive information, I am:

- building multiple table visuals in PowerBI (1 table visual on each of the 4 pages of my report, so total of 4 table visuals. They use the same fields, just different filters)

- 10 column fields are pulled in from 2 different DirectQuery sources 

- 1 column field is pulled in from SharePoint 

I have tried a few times on different versions of the same design file, and I notice that I will randomly run into the error as mentioned in the post. 

1. Instance 1: I got the error after I added the column from Sharepoint, and I noticed that the error occurred when I used columns from Table A. The error didn't occur if I used other fields from other tables, even if they were from the same DirectQuery source. The strange thing is, this error only occurs on the table visual on my 1st page, the other 3 table visuals on my other 3 pages work perfectly even though all use the same fields just different filters.  
2. Instance 2: When I added the column from Sharepoint, all was fine. However, if I try to add a 12th column (using a field from DirectQuery source), I get the error. Error would be resolved if I didn't add this 12th column. I get this error accross all pages of my report. 
3. Instance 3: After Instance 2, I found that if I changed my relationship of the Sharepoint table from one to one to many to many, the error would be gone, but my table visual would show information in the wrong way in my Sharepoint column (instead of showing one value like it is supposed to, it shows all the possible values). I get this error across all pages of my report.

I am referencing this post (Solved: Refresh Failed:  'file 'pfoledbreader.cpp', line 8... - Microsoft Power BI Community ) that mentioned that the November 2023 update resolved this issue, but I am running on February 2023 version and am facing this problem.