Get or connect to data
- Import mode loads data into the VertiPaq engine, giving the fastest visuals and full DAX, but the report only shows data as fresh as the last scheduled refresh.
- DirectQuery sends queries to the source for every visual, so data stays current, but performance depends on the source and some transformations are limited.
- Dual storage mode lets a dimension table act as Import or DirectQuery as needed, which keeps relationships regular when facts use different storage modes.
- A live connection to a published semantic model lets authors build reports on a shared model without copying it, and requires Build permission on that model.
- Privacy levels decide whether Power Query can combine and fold data across sources, so a Private source is never sent to another source during evaluation.