Forum Discussion

SStough's avatar
SStough
Frequent Visitor
6 years ago
Solved

Show Data bug when the first column is a URL

The Show Data view of a Power BI table is displaying the entire comma-separated value list as a hyperlink. This is causing all of the columns following the URL to be sent as invalid query string values. This does not happen if the URL is not in the first column. The URL displays correctly in the Table visual, but the issue only exists on the Show Data comma separated view with or without the URL icon setting. I am using the SQL Analysis Services tabular model with a live connection and the URL field is coming in as a string value from the DB.

 

Does anyone know a better fix than moving the URL out of column 1? 

 

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi SStough ,

     

    The issue had been fixed. Please have a try. Hope it is working perfectly on your side.😉

7 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi SStough ,

     

    Sorry for that, but we cannot reproduce this on my side, could you please try to reproduce it with the latest version of Power BI Desktop?

     

     


    Best regards,

     

    • SStough's avatar
      SStough
      Frequent Visitor
      6 years ago

      Thank you for the reply. I just downloaded the latest (January 2020) version and retested using a .CSV import and I am seeing the same bug. I included the steps below in case you want to take another look.

       

      1. Create .CSV file with a few text columns. One column will need to contain a valid URL.
      2. Import .CSV using the Get Data option on the Home Tab.
      3. Format URL field
           â€¢ Fields Tab (Right): Select\Highlight the URL filed that was imported
           â€¢ Modeling Tab (Top): Click Data Category (dropdown): Select Web URL
      4. Add a Table to the Page that includes the imported columns
           â€¢ The text columns should show up black and the URL should be displaying as a hyperlink (underlined and blue).

       

      Now when you click the … Show Data option on the table. You will see the table at the top of the screen and the data in the bottom pane. If the URL is the first field in the table it will include all of the columns in the link as invalid query string values. If the URL is not the first column it will display and work correctly.