Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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_ Caitlyn
Thank you @v-xiaoyan-msft,
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?