Forum Discussion

praveenk924730's avatar
praveenk924730
New Member
11 months ago
Solved

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

I am getting the below error message while refreshing the power bi in desktop and also in the services (both manual and scheduled refresh).     This is happening for all the reports. ...
Need Help
  • praveenk924730's avatar
    praveenk924730
    11 months ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi praveenk924730,

Thanks for reaching out to the Microsoft fabric community forum. This error (Cannot execute<ReadChunkWith

Retries>… after 5 tries) usually indicates that the connection between Power BI and your data source is failing at the command/query level. Since you’ve already tried different machines and networks, the issue is not local.

Please try these steps. In Power BI Service go to Dataset then Settings and then Data source credentials, now re-enter and save the credentials. If you’re using a gateway, make sure it’s online, updated to the latest version, and the data source is mapped correctly. Now test by creating a new PBIX that connects only to the “Opportunity Analysis Data” table, if it fails, the problem is with the connector/source, not your report.

If the issue persists, open a Microsoft support ticket and provide the Activity ID, Request ID, and Timestamp from the error message. You can reach out to Microsoft Support by raising a ticket with Microsoft Support. Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.