Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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?