Forum Discussion
Solved
Refreshing data with dependencies
Hi, I have the following queries or tables set up 1: Import static CSV file 2: Import dynamic CSV file from a web query 3: Combine 1+2 (static and dynamic) 4: Get column names from 3, matc...
To the best of my knowledge, queries do not update their dependencies, would make a nice Idea though. You might consider digging into the Advanced Editor and finding a way to combine your queries into a single query. I have a blog article on this "Power BI: Merge Queries with M". You should be able to do something similar I think.
This is the best workaround I've found for the issue (have tables with different refresh options in the query editor, and then union them together with DAX on the front end)
http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/