I'm connecting from facebook to power bi, but it's not working because a message says "Time expired"

I’m connecting from facebook to power bi, but it’s not working because a message says “Time expired”

“the operation timed out”

how to solve this?

Niklas: oh
does it work with shorter timeframe?

yes, with 7d

Niklas : ok

but I need as much time as possible, from 6 months to 1 year…

Niklas: just a moment im checking

ok

Niklas: is it always this query you would need?
we would have to cache it
do you need all the accounts at once?
because that slows it down also to pull all accounts at once

i need all accounts… can i pull data from all accounts one by one?

without changing my plan and paying more for it?

Niklas: yes that should work
other option is that we cache it

ok
I’ll try

Niklas: or if you can pull it in increments to powerbi
you know how to select accounts in onboard form?

yes I had selected all

Niklas: ok
you have to do it on the destination page

ok

thank you

Can you tell me if there is any way to customize an API so that I bring data from the year 2018 to the current data, so that it automatically updates in powerbi?