I have several ideas! However, to make sure I answer your need concisely and most correctly can you answer the following:
1. What kind of data source(s) are you working with?
2. What kind of machine are you working with?
3. How many data sources of each type are you working with?
Thanks! I'll reply to your reply as soon as I can.
Hey @pescem2 check out this thread on changing the timeout of the oracle sql query: https://community.powerbi.com/t5/Desktop/Oracle-ORA-01013-how-to-change-the-timeout-setting-for-orac...
Let me know if it helps.
In that case I would either google ways to make your SQL queries more efficient or manually refresh in desktop and republish to service.
Can you share your query?
I did happen to add another clause into my WHERE statement that limited the data. The service has been able to update the dataset since this clause was added.
Back to my original question though...why would a dataset take more time to update in Service than Desktop?
@pescem2 That is a good question. Simply put though, it is because the service has to go through the same steps as the desktop version of the report except that Power BI Online Service has to do it all through the Data Gateway and it relies on the speed of the internet connection. This adds an extra small step, but it certainly slows it down. I have noticed this in my reports as well which Is why I try to keep them fairly simple as far as teh dataset is concerned. I'm not querying anything quite as large as you are thoug and luckily mine are all Microsoft SQL Databases instead of Oracle.