Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

.XLSX Hyperlink Column Pulling Empty into Power Query

Hi everyone!

 

I’m pulling an .XLSX file from SharePoint that has one column that’s full of hyperlinks. When I pull it into Power Query, the column of hyperlinks is blank, with just the column header. The other columns look good.

 

When I open up the .XLSX file in SharePoint, I’ve noticed that it has a short delay when loading the hyperlink column. I had wondered if Power Query was pulling the data in before the hyperlink column had a chance to load. However, I tried pulling in other .XLSX files that had columns of hyperlinks and no delay when opening the file in SharePoint, but they also showed up as empty. So it seems like the delay in SharePoint isn’t the issue.

 

Does anyone have a fix for the empty column? I don’t need to maintain the hyperlinks. I just need the text from them. Thank you in advance!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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!

View solution in original post

7 REPLIES 7
collinq
Super User
Super User

Hey @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."

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

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.

 

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 User




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

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.

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"?





Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

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!

Hey @Anonymous ,

 

Thanks for the update!  That is interesting to know.  This is new knowledge to me and I suspect others that read this thread in the future.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors