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.
Hello Power BI Community,
I'm currently working on a project where I need to connect Power BI Desktop installed on my laptop to a SQL Server database hosted on AWS belonging to a customer.
Could someone please explain the differences between live connection, import, and direct query in Power BI? I want to understand the implications of each approach and determine which one would be most suitable for my scenario.
Thanks,
Manoj Prabhakar
Solved! Go to Solution.
Hi @manoj_0911
Please refer to the below detailed articles on live connection, import, and direct query in Power BI and advantages disadvantages, which should be selected for which solution etc
https://www.linkedin.com/pulse/power-import-direct-query-live-connection-bi-aditya-singh/
https://www.phdata.io/blog/import-vs-direct-query-power-bi/
https://blog.enterprisedna.co/power-bi-import-vs-direct-query/
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Hi @manoj_0911
Please refer to the below detailed articles on live connection, import, and direct query in Power BI and advantages disadvantages, which should be selected for which solution etc
https://www.linkedin.com/pulse/power-import-direct-query-live-connection-bi-aditya-singh/
https://www.phdata.io/blog/import-vs-direct-query-power-bi/
https://blog.enterprisedna.co/power-bi-import-vs-direct-query/
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |