So I have an annoying issue that I am not really sure what the best way to tackle it is... when querying for data in Power BI using the Adobe Analytics connector, if more than four days passes, it starts timing out. I have quite a complex query though, with five dimensions which I need to get data out per day for a couple of months. I know that the Adobe API is built more for quick, shorter queries, so this one just keeps timing out.
Two things that I am thinking about doing, is:
1) Split up the queries to daily instead, but I do not know how I would go about or even start to do that. Say my date range is 2021-01-01 to Today, I'd like to be able to split that up by day, query it per day and then append the queries to a new table. No idea how I'd go about doing that though... any tips would be helpful!
2) Break down one dimension at a time. The only common identifier I have is an ID that is the common between all dimensions. Say, for sake of simplicity, I'd have ID1, then I was thinking on querying the pages where ID1 was present for the remaining four other dimensions. I know how to do it in report builder, but I can't get the same to work in Power BI.
Any tips, thoughts or ideas would be highly welcome!