Direct Query, Live Connection or Import Data? Tough Decision!
Power BI supports different methods for connecting data. That is why the decision to choose the right method is always a tough decision. You have heard of DirectQuery, Live Connection, and Import Data. What these three actually means? and what is the situation that you should choose one over the other one? What is pros and cons of each? What are best practices to choose each? Which one is faster? which one is more flexible? Is DirectQuery and Live Connection actually one thing? or two separate methods? And many other questions. I always get a lot of questions like this in my courses, conference talks, and blog posts. In this post, you are going to get the answer to all questions above. This post helps you to choose the right data connection methodology and architecture for your Power BI solution. If you like to learn more about Power BI; read Power BI book; from Rookie to Rock Star.
Read rest of the article here:
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Rafael Durbano Neto, artigo MUITO interessante
Data Analyst
7 年Reza, this was a great post, and a complicated topic. How hard it is to answer this question..."What are the data refresh options in Power BI?" Consultant..."Well, it depends on the type of data source you have. It depends on if you have the gateway installed. It depends on what choice you make in the Get Data section of Power BI. It depends on whether or not you Get Data in Power BI Desktop or the Power BI Service." Argh!
Power Platform Expert, Microsoft MVP, Sr. Director NA at Stridely Solutions, Founder at Insight2Actions Inc.
7 年Great article. Must read for all Power BI users.
PL-300 Certified Power BI Specialist, Jobs and Skills Australia
7 年Great article! Very well explained
Data Practitioner | Cloud Analytics | Azure | Databricks | GCP | AWS
7 年Thank you . Great post.