OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider:

[Rimi_2095]

Hi Team,

I'm getting bellow shown error while fetching one table from Power Query Editor to Power BI Desktop.

OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider: 'Invalid operation. The connection is closed.'.

I could see no error in that particular table in power query editor but when I'm fetching it to desktop this popup is coming after few minutes of loading.

@amitchandak  @Greg_Deckler  @lbendlin @Jihwan_Kim  @Ahmedx @Padycosmos @Arul @DataInsights @ppm1 @Sahir_Maharaj @MFelix @AllisonKennedy 

 

[AllisonKennedy]

@Rimi_2095  Power Query Editor only loads a preview of the data, so errors sometimes don't appear until you 'close and apply'. What's your data source? If you're still experiencing an issue have you tried raising a support ticket?