teradata

[srilathakurra]

Hi

We are connecting from our PBI Desktop to Teradata (using an ODBC connection) to export data and we have selected parallel Load option. Post the data export, once we make any changes and click on Apply Changes, we see that PBI is creating multiple ODBC sessions to TD . These sessions just seem to be in a Responding State in teradata. We are trying to understand the logic behind spawing multiple sessions, how is the number decided and how do we explicitly logout from the sessions? Sometimes these sessions just do not disconnect unless they are explicitly done so by Admin team.

Any help is appreciated.

Thanks

[v-yulgu-msft]

 Hi @srilathakurra ,

Per my knowledge, each time applying any change in Query Editor would run the data connection query. Please refer to below links to use SQL Profile to analyse query performance.

Connecting SQL Server Profiler to Power BI Desktop

Deep-dive into query performance with SQL Profiler and Power BI Desktop

Regards,

Yuliana Gu