![]() Out of the 1000 times i tried to pull Oracle data using Power Pivot, i was able to see Power Pivot importing rows of data once but i stopped it before it was able to finish. ![]() Object reference not set to an instance of an object.OLE DB or ODBC error: ORA-01005: null password given logon denied.The next step provides a status of the import which i get one of the below error messages: I select the table, preview it and apply some filters (which i can see the data), then i press "Finish" to commit to pulling the data. Next step in the Import Wizard is to view the tables that are available to pull. I tested the connection to Oracle and it works. The provider i chose is "Oracle Provider for OLE DB". To connect to Oracle, i used Table Import Wizard in Power Pivot and entered all the required info (Server Name, User Name, Password). I have an issue where i'm trying to pull some data from an Oracle table via Excel Power Pivot.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |