Power BI and MapR Drill error

[Selva]

Hi,

I get the following error when trying to connect to MapR cluster via ODBC drill driver.

DataSource.Error: ODBC: SUCCESS_WITH_INFO [01000] [MapR][Drill] (2010) Schema Changed in the result set: Late-appearing columns were not returned in this result set. Please create a view and/or resubmit your query.
Details:
DataSourceKind=Odbc
DataSourcePath=authenticationtype=plain;connectiontype=Direct;driver={MapR Drill ODBC Driver};dsn=MapR Drill;host=172.11.20.23;port=31010
OdbcErrors=Table

Power BI is showing the drill schema , HIVe tables and views.

My Drill driver is 32 bit and Power BI is also 32 bit

Please advise.

[v-yulgu-msft]

Hi @Selva,

Could you connect to MapR and fetch data successfully from other client tool? Did you make any change to source data?

Here is an article written about how to connect to MapR in Power BI desktop, please check whether you have something missed.

By the way, do mask sensitive data before uploading error log.

Regards,
Yuliana Gu

[Selva]

That is exactly the process I have followed.
 
Event viewer generates an error when I open the power BI. Power bi is 32 bit installed on 64 bit machine
 
Error details
 
The description for Event ID 11 from source MSOLAP$AnalysisServicesWorkspace329682563 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
 
If the event originated on another computer, the display information had to be saved with the event.
 
The following information was included with the event:
 
msmdsrvi.rll
3081
 
Please advise

[Selva]

I am able to connect to any source using Drill explorer via ODBC

[Selva]

Solution?

[abhi1488]

I am also facing the same issue when trying to import the data from drill to Power BI..any workaround for this?

[Selva]

That is exactly the process I have done. 

Event viewer generates an error when I open the power BI. Power bi is 32 bit installed on 64 bit machine

Error details

The description for Event ID 11 from source MSOLAP$AnalysisServicesWorkspace329682563 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

msmdsrvi.rll

3081

Please advise