Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have been banging my head against this for a little bit, and the crazy part is I have gotten it to work before but cant figure it out again.
I have a table in an excel file that has 20ish columns, one of them being a URL column that is a concat of a base string and another column. I store this excel file in SharePoint, and then access it from PowerBi. After loading in all my data, I cant make the URL column's data render as a clickable URL. Right clicking the data column does not have the "Web URL" format type (not even grayed out, its not there at all). So I am at a loss, and I am not sure what I am doing wrong.
As I mentioned, I have gotten this to work before in a very similar project. I have gone through all the settings side by side and they appear identicle.
Solved! Go to Solution.
Hi @jordanberry89,
I test on my side and it can be recognized as hyperlink and open it on web browser.
Please add "https//" prefix to your url string and set up 'Date Category' to 'web url' enable hyperlink feature, otherwise power bi will recognize it as normal text string.
Regards,
Xiaoxin Sheng
Hi @jordanberry89,
I test on my side and it can be recognized as hyperlink and open it on web browser.
Please add "https//" prefix to your url string and set up 'Date Category' to 'web url' enable hyperlink feature, otherwise power bi will recognize it as normal text string.
Regards,
Xiaoxin Sheng
Hey @v-shex-msft,
Thank you for your help! I had the https:// added to the string, but what I was missing was setting the data category in the modeling view. The way I was trying to do it was going to the dataset and trying to cast it to a web url from a string.
My dashboard is working as expected now! I will make your post as the answer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |