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!
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!
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.