Sep 17 2021 02:36 AM - edited Sep 17 2021 03:44 AM
Sep 17 2021 02:49 AM
@Thomas_-BA For each of the queries you can set the Refresh Controls under Query Properties.
But why not transform the one-time output of the query to the CSV file into a static table?
Sep 17 2021 03:17 AM - edited Sep 17 2021 03:24 AM
Thank you for your help, I'll try that now.
Indeed, I think it would have been more convenient the use this method. I am used to composing projects on PowerBi and composing all my queries from the query editor. I had to switch to Excel for this project and I noticed the same query editor, so I wanted to compose all my data from there.
So I imported my csv file into that editor so that I could merge the data included in that file with some of the data acquired with API. It's getting hard to backtrack now without having to add several days of development.
EDIT : I think I may be in a bad situation because of that, I tried to refresh again and run into the same error because of the merging : "[DataSource.Error] Could not find a part of the path 'C:\Users\***\Desktop\all.csv' "
Sep 17 2021 04:30 AM
Query won't be refreshed, but you can't remove data source at all if you have dependant queries.