Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Query Banding

Hi Team,

 

I am looking for how to define "Query Banding" in Power BI desktop. Query band statements run during connection and helpful for database team to identify the query coming from different reporting tools.

 

Thanks,

Ravi

Need Help

7 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous 

     

    You may new a query in query editor and check it in Advanced Editor. For further,please refer to this article.

     

    Regards,

    Cherie

    • Levajar's avatar
      Levajar
      Advocate II
      7 years ago

      Is it supported on Power BI the query band feature ? Especially when working with Teradata as the Reporting warehouse. Please advise. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      its not realted to the question asked.

      Query banding is teradata native feature, which can be set on at
      1) Session level
      2) Transaction level

      Setting Query Band allows user to categorize queries running through Power BI.

      it is supported in Tableau , Informatica , Microstatergy , Cognos

      But I dont think Power BI supports native Query to Teradata
      and currently they dont support Query banding as well.

  • pondrace's avatar
    pondrace
    Frequent Visitor
    4 years ago

    Is there any news about this topic? Does Power BI support Query Banding or is it in the roadmap of Power BI?

    Thanks

    Pavel

  • TrevLc's avatar
    TrevLc
    Helper III
    4 years ago

    Hi,

    Is there any update on this? I am also looking at using query bands for my reports which connect to Teradata

  • jbretana's avatar
    jbretana
    New Member
    3 years ago

    I would like to know if it's possible to use QueryBand (TERADATA) on my Power BI reports. I can't find the option. 

    Thanks.

  • migs's avatar
    migs
    Frequent Visitor
    2 years ago

    I tried settting the Teradata query band parameter through data source settings. There is a SQL Statement field within Advanced Options in the same dialog box where you enter the Teradata server name. I entered a statement like the following:

    SET QUERY_BAND='LoginUser=my_user_1;ProxyUser=my_proxy_user;' FOR SESSION;

     

    When I click on Apply changes, I'm getting the following error message:

    "This native database query isn't currently supported."

     

    Is there any other way to use query banding?