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

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]


  • cygnex's avatar
    cygnex
    Advocate II
    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.