I have two files in Onedrive for Business: file A and file B.
File B is then used as a source of dataset for Power BI reports.
File A is raw data updated in other flow and it works perfectly.
File B has Power Query connection to file A and also adds some columns and vlookups to data from file A.
I setup file B to refresh when opened and cleared all info regarding trust policy.
I want to create schedule flow to refresh file B on a daily basis.
I was able to connect everything together but file B is not refreshed.
1. Get file content
2. Initialize variable - add 120 seconds
3. Delay until - variable from previous step
4. Update file - get file content from step 1
Any help appreciated.
