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. 

Power_BI_Neo's avatar
Power_BI_Neo
Regular Visitor
3 years ago

I have the same problem. I'm using 'DirectQuery for PBI datasets and AS' preview feature but I also have a calculated table. If i remove the calculated table the refresh works.