Forum Discussion
Power BI - AWS Redshift
I'm creating Power BI Reports and my source is AWS Redshift, when I'm checking the AWS Redshift Portal, I found that Power BI executes this query (select 1) more than 200 times every day, and that increases my cost on Redshift.
why does that happen?
how can I prevent this query from executing?
and there are queries executed alone like this:
2 Replies
Hi AHMRayyan ,
Power BI has two main ways to model data, Import and DirectQuery. If you’re using the Import method, Power BI needs to connect to the data source to import data, which could lead to frequent queries. SELECT 1 Switching to DirectQuery could help reduce these queries, as data is not imported or copied into Power BI, instead, queries are sent directly to the underlying data source.
Best regards.
Community Support Team_ CaitlynThank you Anonymous,
Do you know any way to stop executing these queries or at least (Select 1) query, because it increases AWS Redshift cost without using DirectQuery instead of Import?
