ORA-01013: error when loading millions of rows from oracle

[Anonymous]

I am using an oracle view as source for my power bi report, the view has millions of rows....when I am loading the data into the power bi desktop (select * from view),  I get the below error

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Oracle: ORA-01013: user requested cancel of current operation. '.

Is it because power bi cannot handle millions of rows to load ? Note, once loaded, I can put slicers to reduce the data, but this error is happening when I am loading

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @Anonymous ,

Based on my research, we think it might because the query timeout value, please try to Check the Oracle ODBC Driver Configuration for the Data Source. Clear the option for Enable Query Timeout. Or try to increase the timeout value in Power Query Editor:

let
  Source = Oracle.Database(server, [Query = "XXXXXX", CommandTimeout = #duration(0,2,0,0), ConnectionTimeout = #duration(0,2,0,0)])
in
  Source

Best regards,

[Greg_Deckler]

I've loaded tens of millions of rows in Power BI. Hard to tell what might be going on. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".