Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Winniethewinner
Helper III
Helper III

Power Query Editor slow for all steps - from loading data to even add an index column

Hi everyone, 

My data connection to PBI is super slow, so I would like some advise / suggestions. 

We get data from ODBC driver: 

Winniethewinner_0-1648153759557.png

And then define the DSN, and have a SQL statement: 

2022-03-24_16-31-01.png

The SQL query generates about ~2 million rows. When I run the query in SQL assistant it takes ~4 mins to run. But when I copy paste the query to this PBI SQL statement, it takes several hours to load. 

 

Also, after the data is loaded, and if I perform extra step - for example simply add an index column, it takes another several hours to perform. This load takes very long to perform.  

Winniethewinner_2-1648154213289.png

 

Can someone help me what could be the underlying reasons? Any advise or suggestions is much appreciated. Thank you.   

 

1 ACCEPTED SOLUTION

Hrm... yeah. that might be the way. When searching for info on Power BI and Terradata, there are several 3rd party tools that make it fast, which suggests it is slow as a rule, so I think the issue here is finding a good connector. I have no experience directly with Terradata databases, so I don't want to post links you can google yourself. You could repost a new question and put slow Terredata in the description and someone with that experience is more likely to see it.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

4 REPLIES 4
edhans
Super User
Super User

What is your data source and why are you using an ODBC driver vs the driver for your server? For example, use the SQL Server connector if it is that, vs an ODBC driver for SQL Server. 

We need more info.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Thanks for your reply @edhans . 

The data source is Teradata. Actually I'm not very familiar with the database connection. The way I connected is how I was instructed. If there could be other way (more efficient way) to connect, can you please instruct me how, and what type of information is needed? For example if selecting SQL Server, where could I get the Server name? Apologies if it is a dumb question. 

Winniethewinner_0-1648215128715.png

 

Hrm... yeah. that might be the way. When searching for info on Power BI and Terradata, there are several 3rd party tools that make it fast, which suggests it is slow as a rule, so I think the issue here is finding a good connector. I have no experience directly with Terradata databases, so I don't want to post links you can google yourself. You could repost a new question and put slow Terredata in the description and someone with that experience is more likely to see it.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Thanks @edhans. That sounds an idea - to post a new Teradata-related question. 

I also contacted our Teradata vendor see if they could help. 

Wil accept your solution.  

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors