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 working on power bi connected to a redshift cluster using the default driver that comes within power bi, the simba driver odbc. We are experiencing really poor performance of queries comparing the execution time through power BI and sql workbench. Summarizing the same query takes 4 times more to run within power bi than on sqlworkbench using a jdbc driver.
Is it possible to replace the odbc driver, for the official redshift driver released by Amazon and keep the direct query working?
regards,
tks.
Solved! Go to Solution.
hi, @felipefrutuoso
After my test, I'm afraid it couldn't achieve in Power BI for now. You may try to transfer data by other data source. e.g. SQL.
And you could post your new idea in Power BI ideas and make this feature coming sooner.
Best Regards,
Lin
hi, @felipefrutuoso
After my test, I'm afraid it couldn't achieve in Power BI for now. You may try to transfer data by other data source. e.g. SQL.
And you could post your new idea in Power BI ideas and make this feature coming sooner.
Best Regards,
Lin
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |