Forum Discussion

KKaki's avatar
KKaki
Regular Visitor
10 years ago
Solved

Unable to turn-on hyperlink for columns when using direct query

I am designing a report using a data model that sources data from a Direct Query(SQL).

 

How to enable Hyperlink for a column data in a Data grid? I see only two sections, Report and Relationships, below are the menu items I see.

 

Relationship Section - Data Category DDL is not available.

 
 

 

 

Report Section - Data Category DDL is disabled.

Also, I didn't see Modeling Tab/Data Category DDL in Query Editor  Mode.

 

How can I enable it?

 

Below PowerBI article really didn't help. As it talks only about in memory tables.

Hyperlinks in tables

Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi KKaki,

    Firstly, no matter we connect to SQL Server via Import option or DirectQuery option from Power BI Desktop,  Modeling Tab and Data Category  don’t exist in Query Editor  Mode.

    Secondly, when we connect to SQL Server via DirectQuery option, there are some limitations, for example, only Report View and Relationship View are available in Power BI Desktop. For more details about using DirectQuery in Power BI Desktop, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/ .

    Thirdly, in your scenario, if you have the URL column, you can turn-on hyperlink for it in Report View. Please click the URL column in the Fields panel  of the following screenshot, then you can click on Modeling in the Desktop ribbon and change the Data Category to Web URL.



    Thanks,
    Lydia Zhang

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi KKaki,

    Firstly, no matter we connect to SQL Server via Import option or DirectQuery option from Power BI Desktop,  Modeling Tab and Data Category  don’t exist in Query Editor  Mode.

    Secondly, when we connect to SQL Server via DirectQuery option, there are some limitations, for example, only Report View and Relationship View are available in Power BI Desktop. For more details about using DirectQuery in Power BI Desktop, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/ .

    Thirdly, in your scenario, if you have the URL column, you can turn-on hyperlink for it in Report View. Please click the URL column in the Fields panel  of the following screenshot, then you can click on Modeling in the Desktop ribbon and change the Data Category to Web URL.



    Thanks,
    Lydia Zhang

    • t-atgeor's avatar
      t-atgeor
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Hi Anonymous,

       

      is there a way to rename the hyperlink, it's  highly uncomfortable having all these long URLs which I could simply rename as Link or Tracker,etc. ?

       

      Thanks, Atanas

    • dHarb's avatar
      dHarb
      New Member
      8 years ago

      Anonymous, The whole issue is that in direct query the Data Category drop down is disabled (in the modelling tab). Did you create that screenshot with a direct query report ? 

    • dHarb's avatar
      dHarb
      New Member
      8 years ago

      @Lydia Zhang

       

      Anonymous

       

      In direct query (connection to an SSAS Tabular Model) the Data Category drop down is disabled (in the modelling tab).