Forum Discussion
Keep Hyperlink clickable in Excel
Hello Everyone,
I have a Power BI report that contains a table visual, and one of the columns includes Web URL (hyperlink) data.
When I export the data from Power BI Service to Excel, the URLs are exported only as plain text and are not clickable hyperlinks in the downloaded Excel file.
My requirement is to retain the clickable hyperlinks in Excel exactly as they appear in the Power BI table visual.
Since this export needs to happen regularly, I am looking for a way to automate the process so that the links remain clickable in the exported Excel file without requiring manual conversion.
Could anyone suggest a reliable approach or workaround to achieve this?
Possible solutions using Power Automate, Python, or any other method would also be helpful.
Thank you in advance for your support.
I dont think it is feasible to preserve clickable hyper link behavior in the excel export.
One workaround that I would like to suggest is power automate. You create the power autoamte flow and which will capture the slicer selections by the user in the report page and executes dax query against your semantic model to fetch the results into the flow. Refer this article for more detailed instructions
1. Lets say your table in your data model that contains a name column and a URL column like this
2. You can add a power autoamte flow button to the report page and add all the relevant columns into the field well. SO that it will capture the filter context
3. You can edit the power automate flow to add actions to execute DAX query against this model
4. Create an excel file with a table containing Name, URL and additional cusotm column with this forumula
5. Inside the same flow you can add actions to add these rows into a table inside the excel file.
5. Then when ever a person clicks on trigger button in the report page, rows will be added to the excel file and clickable links will also get generated
6. Add few more actions to send the generated excel file into user's email address
Hope this helps
Connect on LinkedIn
you can read my articles here: techietips.co.in
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
4 Replies
Unfortunately, Power BI’s native Export to Excel does not preserve Web URL formatting as clickable hyperlinks. The export writes out the underlying value as plain text, even if the column is rendered as a clickable link in the table visual.
In your case the best option would be using Paginated Reports. In a paginated report, you can define the textbox/action as a URL and export to Excel. In many cases, Excel preserves that as a clickable hyperlink much better than standard Power BI export.
I dont think it is feasible to preserve clickable hyper link behavior in the excel export.
One workaround that I would like to suggest is power automate. You create the power autoamte flow and which will capture the slicer selections by the user in the report page and executes dax query against your semantic model to fetch the results into the flow. Refer this article for more detailed instructions
1. Lets say your table in your data model that contains a name column and a URL column like this
2. You can add a power autoamte flow button to the report page and add all the relevant columns into the field well. SO that it will capture the filter context
3. You can edit the power automate flow to add actions to execute DAX query against this model
4. Create an excel file with a table containing Name, URL and additional cusotm column with this forumula
5. Inside the same flow you can add actions to add these rows into a table inside the excel file.
5. Then when ever a person clicks on trigger button in the report page, rows will be added to the excel file and clickable links will also get generated
6. Add few more actions to send the generated excel file into user's email address
Hope this helps
Connect on LinkedIn
you can read my articles here: techietips.co.in
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Hi megha_sharma,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to tharunkumarRTK, cengizhanarslan, for those inputs on this thread.Has your issue been resolved? If the response provided by the community member tharunkumarRTK, cengizhanarslan, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.Hi megha_sharma,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
