Forum Discussion
.XLSX Hyperlink Column Pulling Empty into Power Query
Hi collinq,
It turns out, the issue is at the data source with how the XLSX files I'm using are generated. SharePoint is re-generating the hyperlinks when the excel files are automatically uploaded and that delay is causing Power BI to miss them when it pulls. The current fix is to open the new excel file in SharePoint and let the hyperlink re-generate before pulling into Power BI. I'm working on a more long-term solution to this issue.
Thank you for your help on this!
Hi collinq,
Thanks for your reply! My M365 account automatically updates Excel, so it should be the most current version. I also just updated Power BI.
I don't see the "options" button referred to in the second part of your reply. Do you have a screenshot you could share?
When I manually add a sensitivity label to the file in SharePoint, the hyperlinks are able to pull into Power BI just fine. Does that sound like an issue at my source instead of within Power BI? None of the other columns require a sensitivity label to show up in PBI.
Super UserHey Anonymous ,
Look at this link and the various options and comments:
When importing data from web page using Excel, hyperlinks are lost. How to solve this? - Super User
Hi collinq,
It looks like the issue that user was having was hyperlinks turning into text and not staying hyperlinks when imported. For me, not even the text shows up. Nothing shows when trying to import a hyperlink. I don't plan to use the hyperlinks, only the text, but I need to figure out why it's not even showing that much.
- collinq
Hey Anonymous ,
This one is a conundrum! So, in further research, I found some folks that stated that when the field comes in blank that perhaps your Power BI "Data Type" is not set to text. OR, perhaps in your file itself it is marked as something other than text. Is that possible? Maybe confirm that you are not doing a "change type" after the original "change type"? And/or confirm that the original 'change type" is actually making it text and not something else?
I also saw one thread where somebody talked about the file being .xls and not .xlsx (I see, you stated above it was .xlsx - but, maybe just double check?) Also, maybe just ocnfirm that it is not a .csv and it is only Excel default opening it? (That one is a long shot because if other columns are coming in, this one should too, but, I am trying anything and everything.)
When you hit the drop down on that field for the filter, does it show anything?Are you able to change the Sort order from ascending to descending?
What happens if you select that column and then select Transform and select "trim"?Hi collinq,
It turns out, the issue is at the data source with how the XLSX files I'm using are generated. SharePoint is re-generating the hyperlinks when the excel files are automatically uploaded and that delay is causing Power BI to miss them when it pulls. The current fix is to open the new excel file in SharePoint and let the hyperlink re-generate before pulling into Power BI. I'm working on a more long-term solution to this issue.
Thank you for your help on this!