Forum Discussion
Refresh Failed: 'file 'pfoledbreader.cpp', line 836, function 'PFDBReaderOledb::Bind'). '
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.
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
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?My report was also using a calculated table using the UNION function. I ended up re-designing my report using the new field parameters to work around this issue.
