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.
Thanks so much for getting back to me Greg_Deckler , really appreciate it!
So just to confirm when publishing this new report to the web & schduling a refresh, it will only refresh the spreadsheet and not both the spreadsheet and the live power BI dataset? The live power Bi dataset part with refresh with whatever schedule I have set up on there? Hope that makes sense!
Thanks for your advice for the second query too - I completely agree & will use it as an opportunity to tidy things up!
Thanks so much again,
Helen
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 🙂