Forum Discussion
Golden Dataset Questions
HelenBrunyee If you are using DirectQuery then refresh does not affect DirectQuery data sources, just the data sources in your local model (composite dataset). The second question is tough to answer. If you don't want to lose what you have then you could try adding the DirectQuery connection to your existing reports and then refactoring. Although, I might be tempted to go the other route with that and use it as an opportunity to clean things up. So start a new report with the DirectQuery connection and then copy over only what you need.
HelenBrunyee Yes, that is my understanding. Since for the 2nd report the dataset is a Live/DirectQuery query, from that report's perspective, there is no reason to refresh that data because it is not part of the import model, it is a live connection to a data source that is assumed to be up-to-date.
Greg_Deckler You're a Star! Thank you so much for clarifying 🙂