which queries should i load to data model RRS feed

  • Question

  • I have a number of large queries I am working with and am trying to keep them organized. I want to keep my source queries in a separate folder and then create reference queries to do my data manipulation. For calculation speed and file size efficiency, should I load the initial queries to the Data Model and then only create connections for my references of those queries? or create connections for source data and then load reference queries to the data model? or load everything to the data model? 


    Friday, February 9, 2018 7:14 PM


  • Best is to load just those queries to the data model that you need in your reports (so probably not your source queries).

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Friday, February 9, 2018 9:13 PM