![]() ![]() ![]() Why I can not load data into PowerBI desktop? Where this error cames from?įor the first one, I tried to cast my date column in the following ways, and I always get the ORA-01858 error: It is just one column with no null values. Is there something wrong with PBI or is it with the database? I think it is not the gateway, since I have other PBI reports working with other views in the same Oracle scheme. I have tried this query with other views in the same schema and it works out ok, so I assume it is well written and the problem is in other place. Origin = Oracle.Database("myDatabase", ), If I try to go deeper and use the Power Query advance editor (PBI desktop main menu > edit queries > edit queries > (opens Power query window) > advanced editor ) with something (normal) like this, pulling just one numeric column. (I have also tried Select m圜olumn1 from myView, with the same result) Some internet posts suggest that there could be a problem with the date type, but if I try to pull just one (numeric, with no null values) column and cast it as text. If I try to pull the data from the main menu > Obtain data, with a simple query like select * from myView And I can see the data with the credentials.īut when I try to pull the data into a PBI report (in desktop), I get the error. I have checked the table in Oracle, and the fields (there are 8 columns, not much) are defined as type number, var_char and date. ![]() And I can connect to other tables in the same schema and load the data, but this one new does not load into PBI. The PBI user has permits to see the table. I have previously connected to other tables in that database without problem. I'm trying to connect PowerBI desktop (PBI) to an Oracle table but I get the following error: ORA-01858: a non-numeric character was found where a numeric was expected ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |