Hi,
I have a problem with the update of an API when I publish my report.
Indeed, when I work with PowerBi Desktop and I launch an update I have no particular problem.
However, when I publish my report and I want to schedule the automatic refresh I get the following error message:
"This dataset includes a dynamic data source. Since dynamic data sources are not refreshed in the Power BI service, this dataset will not be refreshed."
I have already used APIs under PowerBi without getting this error message.
For information, here is the request I am making :
let
Pagination = Json.Document(Web.Contents("https://sarbacaneapis.com/v1/campaigns", [Headers=[accountId="XXXX",apiKey="XXXX"]])),
#"Converti en table" = Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Column1 développé" = Table.ExpandRecordColumn(#"Converti en table", "Column1", {"id", "name", "kind", "count", "created", "edited"}, {"Column1.id", "Column1.name", "Column1.kind", "Column1.count", "Column1.created", "Column1.edited"}),
#"Personnalisée ajoutée" = Table.AddColumn(#"Column1 développé", "Personnalisé", each try Json.Document(Web.Contents("https://sarbacaneapis.com/v1/reports/"&[Column1.id]&"/recipients",[Headers=[accountId="615c20a7b95cee62596d6f64",apiKey="1IX-8bdLQSGlgkBdeszp6w"]]))otherwise null),
#"Personnalisé développé" = Table.ExpandListColumn(#"Personnalisée ajoutée", "Personnalisé"),
#"Personnalisé développé1" = Table.ExpandRecordColumn(#"Personnalisé développé", "Personnalisé", {"recipient", "clicks", "opens", "success", "unsubscribe", "bounce", "complaint", "desktop", "mobile", "replies", "softs", "geolocations", "links"}, {"recipient", "clicks", "opens", "success", "unsubscribe", "bounce", "complaint", "desktop", "mobile", "replies", "softs", "geolocations", "links"}),
#"recipient développé" = Table.ExpandRecordColumn(#"Personnalisé développé1", "recipient", {"email", "fields"}, {"email", "fields"}),
#"fields développé" = Table.ExpandRecordColumn(#"recipient développé", "fields", {"CONTACT_ID", "ORIGIN_CAPTION_ID", "ORIGIN_KIND_ID", "STATE_ID"}, {"fields.CONTACT_ID", "fields.ORIGIN_CAPTION_ID", "fields.ORIGIN_KIND_ID", "fields.STATE_ID"}),
#"links développé" = Table.ExpandRecordColumn(#"fields développé", "links", {"{{unsubscribe}}"}),
#"Type modifié" = Table.TransformColumnTypes(#"links développé",{{"clicks", Int64.Type}, {"opens", Int64.Type}})
in
#"Type modifié"
Someone to help me please?
Thank you in advance.
Labels: Need Help
Message 1 of 0
1 View
