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 refres...
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
SaiTejaTalasila
Super User
Super UserHi 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
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?