Forum Discussion
Can't save dataflow - One or more tables references a dynamic data source.
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_secret=FGFGFGFGF&filter[field][0]=date_submitted&filter[operator][0]=>=&filter[value][0]=" & DateParameterText & "&filter[field][1]=status&filter[operator][1]==&filter[value][1]=Complete&page=1&resultsperpage=3000")),
#"Convert
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
6 Replies
- lbendlin
Super User
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
SaiTejaTalasilaHi Anonymous ,
Directly pass some date parameter in your power query and see whether the same error occurs or not.
Thanks,
Sai Teja
- SaiTejaTalasila
Hi Anonymous ,
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-
I hope it will be helpful.
Thanks,
Sai Teja