Forum Discussion
Dynamic Web Api Refreshing
Hi Guys, I have an api which fetches data from social media platforms. Using this api, i created a query that fetches last 10 days of data from the social media and writes it to a postgresql databa...
There is NO GUARANTEE that Power Query will execute your code exactly once. DO NOT attempt to abuse Power Query to write anything into a data source.
Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice? (crossjoin.co.uk)
Find a different way to run your process.
The query is running as expected. Except for the refresh. While refreshing, the dynamic date range is not changing. I dont think there is anything abusive here.
"abuse" in the sense that you are using Power Query for something it was never designed for. Use a proper ETL tool.