Forum Discussion
Manuel123
4 years agoHelper I
Dynamic Datasource automatic refresh
Dear Helpers, I hope there is a solution to my issue: I have an API Call that gets the latest energy prices from ENTSO-E Platform. I call the API as follows: Source = Xml.Tables(Web.Content...
arvindsingh802
4 years agoCommunity Champion
Please refer Solved: REST API Dynamic Datasource aren't refreshed - Microsoft Power BI Community
Setting a scheduled refresh on a Dynamic Data Source in Power BI | by dataninja | DataDrivenInvestor
Manuel123
4 years agoHelper I
Dear arvindsingh802 ,
thank you very much for your reply. I have now this code, however get a 404 error message as I don't know where to put the [Headers=[#"Content-Type"="application/xml"]] Part:
Xml.Tables(
Web.Contents(
"https://transparency.entsoe.eu/api",
[
RelativePath="",
Query=
[
securityToken="MYTOKEN",
documentType="A75",
processType="A16",
in_Domain=#"ENTSO-E-Zone-DE",
periodStart="202112312300",
periodEnd=Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-1),"yyyyMMdd")&"2300"
]
]
)
)
Can you help me out?
Best regards
Manuel