We cannot convert the value null to type Table.

[Ramees]

Hi,

I am using Hive Insteractive query as my backend to connect to Powerbi . I am using Interactive Query beta connector to connect to Hive from PowerBi in Direct Query mode. But I am always getting this error "We cannot convert the value null to type Table" .

The data that I am trying is quite simple with just 2 columns with 4 rows. 

[v-xjiin-msft]

Hi @Ramees,

According to the error message, it means that Power BI cannot convert null value to type.

Generally if your source data is complete with just 2 columns and 4 rows. It will not generate an error. So my assumption is that maybe your source data is not complete, so the connector gets an error when connecting to your data source. Please make a verification about your source data.

Thanks,
Xi Jin.

[Ramees]

Hi ,

Apparently all I had to do was to update my version of Powerbi. I guess there was some issue with version of Beta driver I was using.

[Anonymous]

Hi,

May I please know the version you had and updgraded to?

Thanks and regards

[cnschulz]

Hi, 

What version did you have? What version did you upgrade to? Are you referring to the Desktop or Report Server?

We have this same issue however the data refreshes manually on our report server (August 2018). It regularly fails to refresh on schedule but the manual (web based) refresh works fine (every time). We have tested this on RS Aug 2018 and Jan 2019.