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.
Hello,
I have an excel column (lets call it: “more info”) that contains rows with mixed data: text and hyperlinks in each cell. When imported into Power BI, I would like to split the “more info” column into 2 new columns: one to isolate the text and the other one to isolate the hyperlink.
But when I import this file into power bi, both the text portion and the hyperlinks are treated as text, and changing it to “web URL” in the data type does not do anything (PBI does not differentiate whats text and whats hyperlink for each cell; the hyperlink portion gets converted to text).
Any ideas on how to split the column into 2: a) the text, b) the hyperlink? Or how to convert the hyperlink into an actual URL in Power bi (and not excel)?
Thank you.
Solved! Go to Solution.
Hi @tomekm
In the situation, you can use Power BI Split Columns option to split that column into multiple columns.Please refer to the following document to see if it helps you.
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tomekm
In the situation, you can use Power BI Split Columns option to split that column into multiple columns.Please refer to the following document to see if it helps you.
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is the sample data:
Folder Path | Subject | Importance | HasAttachments | "More info" column: |
\Calendar\ | ABC meeting | Normal | False | Meeting minutes <<<<<<<< (this is the hyperlink) >>>>>> this is the text: Join the meeting to discuss important topics….. |
Agreed, a sample dataset would be nice. If you can identify a reliable delimeter then it's pretty straightforward and could be done in Power Query. Even without a consistent delimiter there could still be some options in PowerQuery or DAX.
Here is the sample data:
Folder Path | Subject | Importance | HasAttachments | "More info" column: |
\Calendar\ | ABC meeting | Normal | False | Meeting minutes <<<<<<<< (this is the hyperlink) >>>>>> this is the text: Join the meeting to discuss important topics….. |
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |