Forum Discussion
Show Data bug when the first column is a URL
Hi SStough ,
The issue had been fixed. Please have a try. Hope it is working perfectly on your side.😉
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,
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.
Hi SStough ,
Thans for your detail steps, we can reproduce it and have the same result as yours, we can use the matrix visual as a workaround currently. We will report this issue and update here if we got anything new.
Best regards,I have quite a few columns, so I don’t have enough screen real estate to use the Matrix after it pivots the data. I will continue to move the URL to column 2 as a workaround for now. Thank you for taking the time to reproduce and report the issue.
