Forum Discussion

ziv's avatar
ziv
Frequent Visitor
8 years ago

populate query

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 ...
ziv's avatar
ziv
Frequent Visitor
8 years ago

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's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    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's avatar
      ziv
      Frequent Visitor
      8 years ago

      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