Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I'm querying a facebook API to get data from ad campaigns, but the API has a limit and can't load all the data in a single query, so I decided to limit it to 500 lines and I want to loop to make a request to every 500 pages until you run out of data.
I tried to make a loop using the offset parameter but it doesn't work with the request I'm making... I realized that when I open the .Json the link to the next page is returned.
How do I create a query that will join all the pages in a single table?
Here's the query I'm using:
let
UrlBase = "https://graph.facebook.com/v17.0/act_636965624958777/insights",
Cabecalho = [Authorization = "Bearer [TOKEN]"],
Parametros = [
fields = "ad_id,campaign_name,ad_name,adset_name,spend",
time_increment = "1",
level = "ad",
limit = "500"
],
Consulta = Web.Contents(
UrlBase,
[
Headers = Cabecalho,
Query = Parametros
]
),
Data = Json.Document(Consulta)
in
Data