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 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

 

 

3 Replies

  • 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