SELECT TOP Expression.Error: The 'offset' argument is out of range.

Question

Hi, I'm trying to run a query that looks like below.

select TOP 1 * from c where c._ts >1535611747
order by c._ts DESC

In Portal Azure, works fine but trying from Powerbi desktop power query is giving me the following error

Expression.Error: The 'offset' argument is out of range.
Details:
-1

Any Ideas?

Thanks

anonymous · Answer

I encountered the same problem, but not using the TOP statement. Further analysis showed that removing the 'order by c._ts DESC' clause did solve it for me. Of course, with a TOP statement ordering may be more is of importance - and I have not yet checked other columns than _ts.

v-chuncz-msft · Answer

mtzvictor,
&nbsp;
The&nbsp;latest version&nbsp;of Power BI Desktop&nbsp;seems to work for me.

mtzvictor · Answer

Really? interesting,&nbsp;I have&nbsp;Version: 2.61.5192.601 64-bit (August 2018) and still doesn't work.&nbsp;I'm not sure if i said it before but i'm trying to connect to a Azure Cosmos DB.&nbsp;&nbsp;

anonymous · Answer

Error is in Nov 2018 update as well.&nbsp; &nbsp; I believe this is an issue with Cosmos DB or possibly OLEDB.&nbsp; &nbsp;It appears that the error is coming from Power BI or the driver trying to parse the query rather than just sending it to Cosmos directly.&nbsp;Vote for the following idea if you think this should be fixed:&nbsp;https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34740922-support-top-and-order-by-for-cosmos-db-queries&nbsp;

Forum Discussion

SELECT TOP Expression.Error: The 'offset' argument is out of range.

4 Replies

Related content

Cells Offset

Dynamic Date Offset Navigator

Error message : Expression.Error

Expression.Error: The 'increment' argument is out of range.

Send Argument