Forum Discussion
Solved
New to Power BI - getting data?
I am new to Power BI. I am sitting with a data warehouse with over 20 years worth of information. The warehouse is built nightly (incrementally). What should be my best practice for getting data f...
Hi skruger ,
In your secnario, Direct query should be your best choice.
As using Direct query,
- DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all of the data with pre-aggregation
- Underlying data changes can require a refresh of data, and for some reports, the need to display current data can require large data transfers, making re-importing data unfeasible. By contrast, DirectQuery reports always use current data
- The 1-GB dataset limitation does not apply to DirectQuery
For more details, please check the online document.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
v-frfei-msft
Community Support
Community SupportHi skruger ,
In your secnario, Direct query should be your best choice.
As using Direct query,
- DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all of the data with pre-aggregation
- Underlying data changes can require a refresh of data, and for some reports, the need to display current data can require large data transfers, making re-importing data unfeasible. By contrast, DirectQuery reports always use current data
- The 1-GB dataset limitation does not apply to DirectQuery
For more details, please check the online document.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery