I am getting <ReadChunkWithRetries>, IDbCommmand Interface Issue while refreshing Power BI reports

We have resolved the issue using the below steps:

Process for Working on Power BI Reports (Big Query Connector Issue)

• APPROACH 1

1. Open Power BI Desktop and go to:

• File → Options and Settings → Options → Preview Features
• Uncheck: Use New Google BigQuery Connector Implementation (if it is checked).

1. In Power Query, ensure that all data sources are set as:

GoogleBigQuery.Database()

       and not as:

      GoogleBigQuery.Database([Implementation=2.0])

• If you see [Implementation=2.0], simply remove that parameter.
• Repeat this check for all tables.

1. Save and Apply the changes.

1. Try refreshing the entire dataset to confirm it works.
2. Once verified, you can proceed with publishing.
   
   
   
   

• APPROACH 2:

1. Uninstall the current Power BI Desktop from your system.
2. Install the older version of Power BI Desktop: Version 2.144.1155.0.

1. After Installation, repeat all the steps from 1-5 from APPROACH 1