Is lang goed gegaan, maar nu in een keer niet meer
/acme-exact-online/odata4/ExactOnlineREST.Incremental.TransactionLinesIncremental@eol?$filter=FinancialYear%20eq%202025%20and%20FinancialPeriod%20lt%207
met query:
select t.*
from ExactOnlineREST.Incremental.TransactionLinesIncremental@eol t
where ([FinancialYear] = :w1 and ([FinancialPeriod] < :w2))
Melding:
itgenboe161
Exception
The data download was cancelled after 5 minutes, 0 seconds, such as by the user navigating away in the Power BI or Power Query user interface.
Please optimize your query as described on Overview of Power BI Performance and Download Size Improvement Techniques - invantive.
Then re-run the query.
Waarom doet hij het niet meer, en hoe moet ik dat oplossen?
Ik heb al een time-out:
OData.Feed("https://bridge-online.cloud/keynius-facility-exact-online/odata4", null, [Implementation="2.0", ODataVersion=4, OmitValues=ODataOmitValues.Nulls, Headers=[Referer = "FLOW_EOL_TRANSLINES 25_H1" ], Timeout=#duration(0,4,0,0)])