I find that the performance of my Power Excel Query is not good.
Especially loading the result of the Oracle Sql query works very slow.
Are there options that can be changed in order to speed up the loading from Oracle into Excel.
Enabling the option Fast Data Load that help much.
Direct Query might help.
Also, see this article:
https://www.thebiccountant.com/2021/01/12/your-oracle-data-import-in-power-bi-and-power-query-is-slow/#comments
Thank you for the answer.
I'm trying to use the OLEDB im my query but i don't succeed.
I always get an syntax error.
The syntax i use is
Provider=OraOLEDB.Oracle;Data Source=DBNAME.XXX.YYY.WW;User Id=uuuuuu; Password=pppppppp;FetchSize=200;
[Query="select
I also tried
Provider=OraOLEDB.Oracle(“Data Source=nn.nn.nn.nn:nnn/DBNAME.XXX.YYY.WW;FetchSize=2000”,
But I always get the message Token Comma Expected and i points to the ; before Data Source.
When I replace the ; by a comma i get the message Equel Expected.
When i cut the space between Data and Source I get another time the message Token Comma Expected now pointing to the ; before User Id.
Can anyone help me with this syntax ?
Thanks in Advance.
Hello,
I suppose the original documentation about this connector can give some guidance.
If not then perhaps this site has some useful info.
Br,
Anders
