Send us a textThis week, we discuss hybrid models.  In short, this involves combining data from direct query or live connection with data that has been imported into the model.There are several reasons why you might want to do this.  As we discussed last week, there are many times that you will need to use a direct query.  The problem is that not all sources (eg Excel) support direct query, meaning we need to import that data.  Equally, if you have a data source using SSAS you don't want to import that as it will flatten the structure.  Finally, we touch on using a hybrid model to provide a pre-aggregated version to access the speed of import and detail of direct query.You can download Power BI Desktop from here.If you already use Power BI, or are considering it, we strongly recommend you join your local Power BI user group here.To find out more about our services and the help we can offer, contact us at one of the websites below:UK and Europe: https://www.clearlycloudy.co.uk/North America: https://clearlysolutions.net/

Ver todos los episodios