Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

.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 head...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!

collinq's avatar
collinq
Super User
2 years ago

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.