Forum Discussion
Refresh Failed: 'file 'pfoledbreader.cpp', line 836, function 'PFDBReaderOledb::Bind'). '
I have been running into the following error during my monthly report refresh - Failed to save modifications to the server. Error returned: 'An unexpected error occurred (file 'pfoledbreader.cpp', line 836, function 'PFDBReaderOledb::Bind'). '.
Nothing in my pbix file has changed since the last refresh so i am confused why this has come up - my rfresh goes well until a terminal window opens for a second and then this error appears.
Any help with finding out whats causing this is appreicated!
Thank you than688, this fixed the issue for me also.
Basically I just created a basic new data table of just a few U.S States, via "Enter Data" on Home screen.
Then put the following at the top of each of my calculated tables:
VAR _Temp = MAX('US States'[ST])Now data can be refreshed.It appears that the update to Power BI Desktop for November 2022 has fixed this issue.
25 Replies
Hi Anonymous ,
This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No:344890500 . Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.
Best regards,
Community Support Team_ Binbin YuThank you for the update 🙂
Thank you for recording this issue, I am also getting this same error on a critical report that has calcualted tables and direct access to a shared dataset.
Fix proposed by than688 worked for me.
Hi all, Microsoft have provided me with a solution after raising a support ticket:
The problem arises in the October 2022 update where a calculated entity references a DirectQuery entity and ONLY DirectQuery entities. Until the bug is fixed, a solution is to ensure all such formulas ALSO reference a loaded data source which does NOT come from DirectQuery. I can confirm this worked for me.
Example: in DAX formulas with no existing variable, you could insert the following in front:
VAR [name] = MAX ('Table'[column]) (as long as the source is not DQ)
RETURN
[original DAX referring to DQ source]Thank you than688, this fixed the issue for me also.
Basically I just created a basic new data table of just a few U.S States, via "Enter Data" on Home screen.
Then put the following at the top of each of my calculated tables:
VAR _Temp = MAX('US States'[ST])Now data can be refreshed.
Hi, I've exactly the same problem.
Thank you in advance
I have the same issue for the past 2 weeks.
Same here
I'm getting the same error as well. Which version of PBI are you using? I'm using Version: 2.110.1085.0 64-bit (October 2022)
Anonymous
Version: 2.110.1085.0 64-bit (October 2022)
2.110.1085.0 64-bit (October 2022). What i think may be causing my error is a calculated table that uses a UNION function. When i delete this table the file refreshes with no problem.
Weird thing is this calculated table isn't new and only this month doesn't want to refresh. Perhaps the new version is causing this? Still not sure.
I think you are right. Microsoft seems to have gotten more strict with their restriction to build calculated tables using direct query data. It used to work fine in some cases, but I had several reports break this month.
Are you using a Hybrid model?
Hello, I'm having the same problem.
I have one PBIX with the data model and several PBIX file (only dashboard with visuals) connected to it, and now, I cannot refresh the PBIX file in local.
I had to reinstall the October version and then, it worked.
Hi, I have the same problem around here.
Version: 2.110.1085.0 64-bit (October 2022)
I have the same issue, I've already updated Power Bi and my computer and it's still not working. Somebody knows what´s happend? or Whatshould we do?
