Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Power BI and API timing out

Avatar

Avatar
Contributor
Level 1
marcush74174295
Level 1

Likes

2 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Contributor
Applaud 5
Validate 1
Shape 1
Boost 1
View profile

Avatar
Contributor
Level 1
marcush74174295
Level 1

Likes

2 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Contributor
Applaud 5
Validate 1
Shape 1
Boost 1
View profile
marcush74174295
Level 1

10-05-2021

Hi,

 

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!

Accepted Solutions (0)

Answers (0)