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!
Super UserHey Anonymous ,
Is the Excel version current? I am wondering about a compatibility issue?
I also found this in a thread "When you choose your table to import, select "options" in the upper right corner and deselect "Import blocks into columns". Click OK then finish your import. This will import the table with its existing formatting, including the hyperlinks."
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.
- collinq
Hey 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 UserHi 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.