Forum Discussion
ODBC connection executes query everytime I make a transformation
I have a table from a datasource in ODBC. It's a query configurated from a Redshift database.
The problem is that after the query is executed and loaded in PBI, in the Transform Data option every change I make with a column PBI sends a request to execute the query again.
For example: after I loaded the table if I change a column type to "Number" Power BI will do that sending the query to execute again in Redshift!!
So if I load a big dataset every change I make or transform the powerbi is sending to the redshift to execute the query again and again... it's terrible for the database because it will have lots of requests from the same query.
It's there a way to stop Power BI from doing this?? I think ODBC connection should have a Import option because it looks like ODBC it's only used like a DirectQuery (every change you make it executes the query again and again). Help please!!
3 Replies
- mahoneypat
Microsoft Employee
In your File/Options and Settings, uncheck the "Allow Data Previews to download in the background". You will then need to "Refresh Preview" when you want to refresh. A good tip is also to add a step early in your query to keep only 10-100 rows while you build, and then remove that step when you are done and want to load.
Pat
