From the course: Power BI Data Methods (2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configuring loading options
From the course: Power BI Data Methods (2019)
Configuring loading options
- After performing the extraction and transformation steps on our data sources, we then load the data tables into Power BI. We can select if we want all or only the selected queries loaded. For example, if we created a list object as a query, we may want to leverage it to create other queries, but we do not want to load it. If we decide to load parameters, they will no longer be dynamic. If you would like to create DAX measures, I would recommend putting them in a separate table so they are easy to see and access their calculations. With define caching is a process where we hide something for future use, which in our case, is data we are going to store in the memory. Caching causes latency issues and large data tables with almost real-time requirements my not benefit from caching. We also do not need to refresh tables we do not cache. And by caching only what we need, we can reduce refresh times. Caching into…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.