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.
Hi,
We are using direct query option to get data from DB(Oracle) to Power BI. Can sombody explain how direct query impact the perfomance of the DB? As we are going to develop mutiple reports using direct query will it cause slowness in the DB?
Regards,
Maddy
Solved! Go to Solution.
Hi Maddy,
Please refer to desktop-use-directquery#important-considerations-when-using-directquery and desktop-directquery-about#when-is-directquery-useful.
Regarding the performance, because most of the data is fetched when the report is consumed, the workload of the database is heavier than the import mode.
Best Regards,
Hi Maddy,
Please refer to desktop-use-directquery#important-considerations-when-using-directquery and desktop-directquery-about#when-is-directquery-useful.
Regarding the performance, because most of the data is fetched when the report is consumed, the workload of the database is heavier than the import mode.
Best Regards,
Thanks Dale for sharing the links.
Regards,
Maddy
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |