Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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', line 836, function 'PFDBReaderOledb::Bind'). '.
Nothing in my pbix file has changed since the last refresh so i am confused why this has come up - my rfresh goes well until a terminal window opens for a second and then this error appears.
Any help with finding out whats causing this is appreicated!
Solved! Go to Solution.
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:
It appears that the update to Power BI Desktop for November 2022 has fixed this issue.
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?
Version: 2.110.1085.0 64-bit (October 2022)
Same here
I have the same issue for the past 2 weeks.
Hi, I've exactly the same problem.
Thank you in advance
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |