Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hey All,
I keep getting an ORA-01013 error when refreshing some complex queries in POWERBI over Oracle DB.
When running the same query in some other SQL programs in the same PC (like PLSQL,TOAD) I get the result after 30 minutes , but still get the result, so I'm sure that it is not a server or client configuration issue.
I'm trying to find out where in POWER BI can I change this setting so I won't get the error.
I found another post that describe an optional solution for an ODBC connection, but what if I wish to work with the native Oracle connection ?
Anyone has knowledge about that ?
Thanks
Solved! Go to Solution.
Just found a solution for that.
Similar to the ODBC timeout configuration there is also a timeout setting for an Oracle connection (with slightly different syntax).
for example to set the timeout for 2 hours :
Source=Oracle.Database(server as text,CommandTimeout=#duration(0,2,0,0)) as table
Yes, you would do this in M-query, typically in one of the first lines
Hi! Where do you apply the settings for changing timeout? Is it M-script for the data source?
Just found a solution for that.
Similar to the ODBC timeout configuration there is also a timeout setting for an Oracle connection (with slightly different syntax).
for example to set the timeout for 2 hours :
Source=Oracle.Database(server as text,CommandTimeout=#duration(0,2,0,0)) as table
To change the timeout you can do in two ways
1. Go and Change in Advance Editor in Power Bi desktop in M-Script or In Applied step in Source by clicking the setting button under that in command timeout section.
where to update the Connection Timeout in PBIX? Check out the below link for screenshot.
https://quantawave.blogspot.com/2024/01/oracle-connection-request-timed-out.html
I am echoing @anitaberg's question below:
@BIXL
"Hi! Where do you apply the settings for changing timeout? Is it M-script for the data source?"
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
56 | |
38 | |
35 |
User | Count |
---|---|
85 | |
66 | |
59 | |
46 | |
45 |