Can't save dataflow - One or more tables references a dynamic data source.

[ToreH]

In Dataflow I am trying to set up an automatic refresh, but I am not able since I get an error message.

In my URL I only want the last 2 days of data. It is working fine inside PowerBi when I refresh it, but not when I want to set up a scheduled refresh. Any suggestions how to solve it?

    DateParameter = Date.From(DateTime.LocalNow() - #duration(2, 0, 0, 0)),  // Default is two days ago

    DateParameterText = Date.ToText(DateParameter, "yyyy-MM-dd"),

    Source = Json.Document(Web.Contents("https://api.alchemer.eu/v5/survey/xxxxxxx/surveyresponse?api_token=zxzxzxzxzxzxzzxzx&api_token_secre...>=&filter[value][0]=" & DateParameterText & "&filter[field][1]=status&filter[operator][1]==&filter[value][1]=Complete&page=1&resultsperpage=3000")),

  #"Convert

[lbendlin · Accepted solution]

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

[ToreH]

I just did , I basically hardcoded the date and it was fine. I want to refresh automatically but only the last days. ANyt suggestions

[SaiTejaTalasila]

Hi @ToreH ,

Try the same thing on power bi semantic model and see whether the same issue occurs or not.If it's not working then I don't think you have any other options other than hard coding the value of parameter or url.

Please refer this threads-

https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Service-with-dynamic-data-sources/td-p/14...

I hope it will be helpful.

Thanks,

Sai Teja 

[ToreH]

It is the same in power BI semantic. I just need to find a workaround. Maybe I can generate the URL in excel, and import the whole string?

[SaiTejaTalasila]

Hi @ToreH ,

You can try that- upload that file to SharePoint folder whenever someone opens that file in desktop you can make power query to run on their local machine automatically and updates the result, but they should have access to SharePoint and your data source(web url).

Thanks,

Sai Teja 

[SaiTejaTalasila]

Hi @ToreH ,

Directly pass some date parameter in your power query and see whether the same error occurs or not.

Thanks,

Sai Teja