Forum Discussion

WKN's avatar
WKN
Helper I
5 months ago
Solved

PBI Desktop data unable to retrieve from Amazon Redshift with Fatal error in Feb 2026 release

I have developed a Power BI template that will retrieve data from Amazon Redshift database automatically when launched. There were no issues in retrieving data from Amazon Redshift until Power BI Desktop was updated to Feb 2026 version. 

 

Error message as below prevent further data retrieval. 

“ODBC: ERROR [53300] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 53300] connection to server at “xxx” (ip), port xxx failed: FATAL: too many connection for user “email””

 

When Power BI Desktop was downgraded to Jan 2026 version, data was able to be retrieved from Amazon Redshift database once more. Is there an issue with the latest Feb 2026 Power BI Desktop app release that prevent data retrieval from Amazon Redshift?

Need Help
Show and Tell
  • v-prasare's avatar
    v-prasare
    5 months ago

    Hi WKN,

    Since this behavior only occurs in the February 2026 Power BI Desktop release and works correctly in January 2026, we recommend raising a Microsoft Support ticket and submitting feedback from Power BI Desktop. This will help the product team review logs, confirm whether this is a regression, and track it for a fix. Please include the Desktop versions tested, the Amazon Redshift ODBC connection, the SQLState 53300 error, and that the issue is reproducible only during dataset refresh
     
     
     
    Thanks,
    Prashanth

3 Replies

  • v-prasare's avatar
    v-prasare
    Community Support
    5 months ago

    Hi WKN,

    Since this behavior only occurs in the February 2026 Power BI Desktop release and works correctly in January 2026, we recommend raising a Microsoft Support ticket and submitting feedback from Power BI Desktop. This will help the product team review logs, confirm whether this is a regression, and track it for a fix. Please include the Desktop versions tested, the Amazon Redshift ODBC connection, the SQLState 53300 error, and that the issue is reproducible only during dataset refresh
     
     
     
    Thanks,
    Prashanth
  • v-prasare's avatar
    v-prasare
    Community Support
    5 months ago

    Hi WKN,

    Currently, Microsoft has not listed known issue that specifically identifies Amazon Redshift ODBC connection failures as a confirmed regression in the February 2026 release of Power BI Desktop.

     

    Try Validating Redshift connection limits:
    Amazon Redshift enforces per‑user and per‑database connection limits. The SQLState 53300 error commonly indicates that these limits are being reached. Check active sessions in Redshift and confirm that connections are being closed properly.

    Amazon Redshift Database connection limit "498" exceeded for non-superusers

     

     

    Try again and let me know if your able to resolve your issue?

     

     

     

    Thanks,

    prashanth

    • WKN's avatar
      WKN
      Helper I
      5 months ago

      I did an experiment to validate the Power BI template data refresh from Amazon Redshift with Power BI Desktop version Jan 2026 and Feb 2026. 

       

      In Jan 2026 version, data can download from Amazon Redshift without issues for single ad-hoc query  (Home > Get Data > Amazon Redshift > Submit SQL statement). Data can also be refreshed without issues into Power BI template (in .pbit or even after when saved as a Power BI Desktop file in .pbix). FYI the Power BI template is configured to retrieve data from 8 different data tables from Amazon Redshift. 

       

      Upgrade to Feb 2026 version, data can download from Amazon Redshift without issues for single ad-hoc query  (Home > Get Data > Amazon Redshift > Submit SQL statement). But encountered below error when trying to perform data refresh in the same Power BI template / Desktop file.

       

      All settings (Options and settings) remain the same in both Jan and Feb 2026 version. Current file > Data Load > Parallel loading of tables > One (disable parallel loading) was enabled since there are >1 data table accessed from Amazon Redshift in the template.

      When it is unable to load in Feb 2026 version, I downgraded back to Jan 2026 version once more and configured Options and Settings. Data was able to load into the template without any errors encountered. Is this not related to Power BI Desktop version?