Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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', l...
Need Help
  • cygnex's avatar
    cygnex
    3 years ago

    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. 
  • cygnex's avatar
    cygnex
    3 years ago

    It appears that the update to Power BI Desktop for November 2022 has fixed this issue. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

JuanOchoa's avatar
JuanOchoa
Frequent Visitor
3 years ago

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?