Forum Discussion

VC's avatar
VC
New Member
1 year ago
Solved

Refresh Failures

Hi, Facing refresh issues failures in service, the reports are refreshing in the desktop. Getting below error: "Cannot execute b__0 after 5 tries. The exception was raised by the IDbCommand interf...
Need Help
  • kc_302's avatar
    kc_302
    1 year ago

    Hi,
    I found a workaround that resolved the issue for me.

    In the query code, look for queries having the `[Implementation="2.0"]` parameter:

    `= Value.NativeQuery(GoogleBigQuery.Database([Implementation="2.0"])`

    and replace them with

    `= Value.NativeQuery(GoogleBigQuery.Database()`

    by deleting `[Implementation="2.0"]`

    It's working fine.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi VC 

Step 1: Open dataset >> Check Data source credentials.
Step 2: Verify Gateway mapping (if needed).
Step 3: Check Refresh History >> Identify if it’s timeout/permissions.
Step 4: Optimize query / test smaller load.

In most cases, re-configuring the gateway mapping or re-entering credentials in Service resolves this error.