I've been doing more tests and the connection is problematic with any API version. It doesn't look like Adobe cares much about that API.

Are you using the 1.0 or 2.0 (beta) API? I'm currently not able to edit my old query and fetch new data from that query onto Power BI. A refresh with the untouched query still works. My connection also times out. 

Ideally it would remember the last five time ranges. Last three would be minimum for me. 

It would be nice to receive a confirmation that this request has been considered. There are similar requests in the community too: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/folders-for-my-workspace-projects/idi-p/338156https://experienceleaguecommunities.adobe.com/t5/ado...

Also waiting on that for a looong time. 

Still nothing regarding that? What a shame, Adobe.

Thanks, I've managed to make this work.

OK, that sounds interesting. OK, I found out how to edit the percentages. Need to make sense of the functions now. Greater than seems to only compare two different metrics. Need to investigate more. 

OK, thanks

Thanks Andrey! That's a helpful solution.