Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Error: "Cannot convert the value null to type table" on loading any table through direct query mode

Using a custom connector that work for builds prior to the latest Jan 2018 build, when making connections via direct query mode and loading a table, an error will show up "Cannot convert the value null to type table". The last ODBC call that is made to Power BI before the error happens is SQLForeignKeysW. Has Power BI's handling of this call changed in the latest build?

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @PBIUser1,

 

There is a new desktop version 2.55.5010.521 released on 2/5/2018. Please update your Power BI desktop to this version then test again. 

 

Best Regards,
Qiuyun Yu 

PBIUser1
New Member

The issue is still present in the February build.

v-qiuyu-msft
Community Support

Hi @PBIUser1,

 

As you are using custom connector, please check if this connector needs to be updated as well. 

 

Best Regards,
Qiuyun Yu