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
Post a Comment