Forum Discussion
Refreshing data with dependencies
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.
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.
Hi again. Can confirm that this worked well and wasn't too hard. I will try to remember to avoid using too many intermediary queries in the future. It seems the file size was also halved by combining all these steps into one query, so probably several benefits from this.
The power query code is now 21 lines. It makes me wish the editor was a bit more code-friendly and could use some highlighting, auto-completion, and support for commenting...
That would be a great Idea to post!
Thank you for the suggestion. I agree it looks promising as a solution, I will give it a try. The only downside is then that I am including a static dataset with a dynamic one and PowerBI will waste some time fetching the static dataset again, or is this handled efficiently?
