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.
I have Version: 2.61.5192.601 64-bit (August 2018) and still doesn't work.
I'm not sure if i said it before but i'm trying to connect to a Azure Cosmos DB.
Error is in Nov 2018 update as well. I believe this is an issue with Cosmos DB or possibly OLEDB. 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.
Vote for the following idea if you think this should be fixed:
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.