populate query

[ziv]

Hi

I'm working on redshift database

the pb populate queries that include all the fields in the table although not appearing in the report,

it make the query to run very slow.

what can explain this?

can it be configured so the pb will populate the query in a differenty with only the columns in the report?

Thanks for assistance

Ziv

[ziv]

Hi

I'm working on redshift database

the pb populate queries that include all the fields in the table although not appearing in the report,

it make the query to run very slow.

what can explain this?

can it be configured so the pb will populate the query in a differenty with only the columns in the report?

Thanks for assistance

Ziv

[v-sihou-msft]

@ziv

Currently, the build-in Amazon Redshift connector doesn't support writing query to retrieve data (like SQL Server connector). Please submit a feature request on idea.

If your query takes long time to run, I suggest you use DirectQuery mode. 

Reference:

Connect to Amazon Redshift in Power BI Desktop

Regards,

[ziv]

Hi

I do use the DirectQuery in the desktop

and I saw the query the redshift run 

my question is why power bi creastes the query with all the fields in the table

Thanks