Send us a text

This week, Andy discovers sound effects!

We also talk about the relative merits of importing data into the Power BI data model vs querying the data source directly.

Import is generally supported by all data sources.  Direct Query and Live Connection are more limited.  Generally speaking, databases are more likely to support Direct Query as well as import; file-based sources tend to only permit import.  A detailed breakdown of sources and supported connection methods can be found here.

It is also worth looking carefully at the implications of using Direct Query before choosing it as method.

Finally, remember if you are connecting to an Analysis Services model, you should use a live connection, otherwise the structure will be flattened and you will have to rebuild it in Power BI.

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/