Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 from the warehouse tables into Power BI? Direct Query or Import? Do I pull in multiple tables that are needed but containing upwards of 10 million records each? Can BI handle that? Or do I write some SQL to limit the number of years that are being brought over from the multiple tables?
Please, any assistance or best practices that could be shared would be greatly appreciated as this will most likely be the foundation for a lot of our reporting/visualizations. I have done a ton of reading online, but have yet to find a true definitive best answer. Thanks.
Solved! Go to Solution.
Hi @skruger ,
In your secnario, Direct query should be your best choice.
As using Direct query,
For more details, please check the online document.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
Hi @skruger ,
In your secnario, Direct query should be your best choice.
As using Direct query,
For more details, please check the online document.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |