Forum Discussion

4Eric's avatar
4Eric
Frequent Visitor
8 years ago

DataSource.Error: ERROR [08S01] [Microsoft][Netezza] (1001) Communication link with server failed.

When trying to connect to some tables in a Netezza Data Warehouse I get the following error:   DataSource.Error: ERROR [08S01] [Microsoft][Netezza] (1001) Communication link with server failed.   ...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi 4Eric,

After research,  an error may occur when the communication link between the driver and the data source to which the driver was connected failed before the function completed processing. Without using Power BI, if you can connect the Netezza Data Warehouse correctly? Work with network and Database administrators to see if there were any system problems during the database action. 

Best Regards,
Angelia

  • 4Eric's avatar
    4Eric
    Frequent Visitor
    8 years ago

    I have spoken to our DBA and there was no issues.  I can click this one table to try and bring it into Power BI and I get this error.  I can then immediately select a different table and it will work just fine.  Could there be a size limit thing going on or is the size of the table taking to long to load and causing this error.  This issue will happen whether I select import or direct query.  Last question would it help to update Power BI drivers, if so where can I find them?