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 in the process of changing the direct query method to import method for which the data source is Teradata views. The pbix has 9 queries in which each of the query has around 2 millions of rows and it is taking huge time say around 6+ hours for refreshing the data after changing the direct method to import method.
Is there any way to optimize this, help is appreciated.
Thanks,
Kishore
Solved! Go to Solution.
Hi @kishoregan,
You may try to disable 'Parallel loading of tables' in PBI Desktop options (it's enabled by default):
Hi @kishoregan,
You may try to disable 'Parallel loading of tables' in PBI Desktop options (it's enabled by default):
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |