Dynamic Datasource automatic refresh

[Manuel123]

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.Contents("https://transparency.entsoe.eu/api?securityToken=" & "MYTOKEN" & "&documentType=A44&" & "in_Domain=" & #"ENTSO-E-Zone-DE" & "&out_Domain=" & #"ENTSO-E-Zone-DE" & "&periodStart=" & "202112312300" & "&periodEnd=" & Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-1),"yyyyMMdd")&"2300", [Headers=[#"Content-Type"="application/xml"]])),

When I publish it to the service it says, that it can't refresh automatic as I use a dynamic datasource. I guess that the calculated period end is the problem. Is there any way to solve this issue or a best practice with dynamic API calls?

I look forward to your suggestions

Best regards

Manuel

[arvindsingh802 · Accepted solution]

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

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

[Manuel123]

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

[Manuel123]

Your solution worked, I had another mistake in my code

[fawa]

Hi @Manuel123 

Can you share your solution?