Error importing data with ODBC (only queries work)


i trying data postgre sql database in powerpivot (via connection wizard).

 

if use commercial oledb driver there no problem if use free odbc driver can access data via queries (without problems) visual selection returns

 

system.nullreferenceexception: object reference not set instance of object.

   @ microsoft.analysisservices.modeler.dataimportwizard.tableselectionpage.showalltablesandviews(object sender, eventargs e)

   @ microsoft.analysisservices.modeler.dataimportwizard.progresscontrol.timertaskcomplete_tick(object sender, eventargs e)

   @ system.windows.forms.timer.ontick(eventargs e)

   @ system.windows.forms.timer.timernativewindow.wndproc(message& m)

   @ system.windows.forms.nativewindow.callback(intptr hwnd, int32 msg, intptr wparam, intptr lparam)

 

can me that?

table , views collections got through defined schema sets. looks odbc driver using doesn't support schema set retrieve tables , views. possible publish odbc driver info using? can try different odbc drivers see whether resolves issue.

thanks,

deva [msft]


deva


SQL Server  >  Power Pivot



Comments

Popular posts from this blog

BIT Version

SQL Server PSProvider SQL Server Authentication

Getting error when using Excel Destination