Error Bug while refreshing

[vijay273162]

Hi Microsoft Support Desk,

Please let us know the fix for this solution, I don't need to take any workarounf to get this sorted. Earlier, I'm able to refresh this Live connection report without any issues.

Error Occured as ::

DirectQuery to AS - Finance Analytics Data Model_ Summarized

Failed to save modifications to the server. Error returned: 'An unexpected error occurred (file 'pfoledbreader.cpp', line 836, function 'PFDBReaderOledb::Bind'). '.

Report Connection : Direct Query (to PBI dataset)

Used some calcuation table with except function

[Anonymous]

@v-rongtiep-msft 

Hi, I am been experiencing the same issue and I see countless people reporting the same error but received no update on this.  May I know is there any update?

Thanks

[v-rongtiep-msft · Accepted solution]

Hi @vijay273162 ,

Have submitted this issue internal to confirm(ICM:344890500), would update here as soon as possible if there is any update about it.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[vijay273162]

Hi Microsoft Team,

Thanks for quick response.

I also noticed that, removing my calculated table where I'm using UNION DAX function, help to fix this.

But I don't need anyworkaround for this.

Since this calculated tables are used in more than 40+ live connection reports.

Please notify ASAP on but fix.