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. 

than688's avatar
than688
Frequent Visitor
3 years ago

I have the same issue. It would be great if someone from Microsoft could confirm.

 

I built a very large costing model for my organisation using Direct Query to Datasets + calculated tables. It all worked a month ago, and now I cannot refresh the model. Has MS really removed functionality, with potentially big impacts (such as for myself) without any comms?