This is too vague, Microsoft. I don't know how to proceed. Using SQL statements to import data from an Oracle database, and refresh works just fine in the Desktop version. Everything is up to date. On-premises Gateway (personal mode).
|On demand||11/8/2017, 3:12:21 PM||11/8/2017, 5:12:41 PM||Failed||The gateway operation has been cancelled explicitly by the user or from a timeout.|
Ive had a project that gets a similar message. I resolved it by shortening the data being returned by one of the queries. It seems like the length of time given for a query to finish getting all of its rows is much shorter through a gateway when compared to refreshing through the desktop.
If you are accessing a SQL server, are you able to limit your query in some fashion? In my case, i added a where clause to the SQL statement to only return items from the last 5 years.
Yes, I've shortened all of them as much as possible via where queries and group by's and select distinct and valid_date=(select max(valid_date) from xxxx) in where statements. Everything is as tidy and minimal as possible.
I have another report with much longer data sets importing that actually works just fine. So I don't think this is it.
Whats the hosted database like? Is it on a PROD server that might have some sort of load shedding? Do you get similar messages if you refresh Off-Peak compared to On-Peak periods?
Please explain what you mean by load shedding and how to check on this in something like SQL Developer. Any questions to the DBA (who is in another country) usually have to be escalated up at least 3 levels of management to get a response.
To put it in Laymans terms. If the database you are accessing is part of a business system that is under heavy use, the system may prioritise what connections get the limited bandwidth. Power BI, if its taking too long, could have its connection cut in favour of higher priority connections.
During off-peak period, you won't have the same overburden on the server, thus if you find the connection works successfully in off-peak periods then you know performance management is the likely cause.
In networking terms, where is the computer running the gateway in comparision to the computer running the desktop version? Are there any variables to account for there? For example, you might be running the desktop on your computer which is at the same physical location as the database, but the gateway might be on a server thats in an office on the other side of the country.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.