Import vs DirectQuery in Power BI
Vložit
- čas přidán 18. 11. 2020
- Should you use Import or DirectQuery data connectivity mode for your Power BI models? Let's make the right choice by comparing the performance and scalability of the two options!
Optimizing DAX video course: www.sqlbi.com/p/optimizing-da...
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...
All I have to do is show this to the client and drop the mic... Grazie, Alberto!
How do you feel about DirectQuery with dataflows created with the enhanced compute engine? Do you think it is best to filter the dataflow for a smaller amount of data, create the model, and then publish and remove the filters, compared to using DirectQuery? It takes a lot longer to import data to PBI desktop (or perhaps it is due to laptops + VPN and multiple Geographies), so it can be tempting to use DirectQuery (also since the dataset will refresh automatically instead of requiring a separate schedule - the refresh of a source dataflow does not trigger the refresh of downstream datasets).
But what if you have users who use the pbi service dashboard without telling you, and you need to click refresh in the backend first in order for them to get the up-to-date info they need? My report is geared toward users who don't know how to use the desktop version.
Which SQL servers are optimized for direct query?
Anyway to connect to a database over SSH tunnel?
U didn't cleared cache, when running the dax 2nd time. Won't that give incorrect server timing?
Was your SQL server on prem or on Azure? I would expect the latter to probably run much quicker.
One thing I am confused by is the refresh experience, I was hoping you might clarify. An advantage of Direct Query is the immediate background refresh of the source data without any scheduled refresh. Is this advantage worthwhile in your opinion, or what do you think the workflow should be for Import Mode to ensure the user experience is good with up to date data (say, new data is being added daily)
Hi Sir I have one question. I make one sales report everyone with one excel as data source. How can I save all these weekly report in the same power BI report so I could look back previous report by clicking the filter.
Alberto what would you do in an environment where the data is held in a SSAS tabular cube, but the dashboard is in Power BI service. Direct Mode or Import Mode?
Power BI is much more sexy with an Italian accent.
Great stuff Marco Russo. Thank you. There is more meat in this video. I will view it at a slow pace.
Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥
Awesome video. Thank you for your expertise and taking the time to share it here.
I was searching for this video and here I am, First thank you, Alberto, great vid!❤
Such a great video and comparison. Thank you for putting this together!
Directquery is also required if you need to keep the data on your own servers, ie. for client data contract reasons.
SQL Server Database
well explained! I am very intrigued by your monitor setup. How do you use 5 monitors / role of each in data modeling? Are you using a special graphics card or a usb adapter for this?
Great video. Thanks Alberto 🌹👍