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.

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

HI VC,

Thank you rohit1991 FarhanJeelani, for youe insights.

Please review the data source credentials and gateway connection, and confirm whether there have been any recent changes to the data source configuration.

Additionally, here are some helpful reference links to assist you with troubleshooting the issue:

Power BI Service – BigQuery connector failing with... - Microsoft Fabric Community

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

 

Thank you.