Keep Hyperlink clickable in Excel

megha_sharma 

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

https://powerbi.microsoft.com/en-us/blog/unlocking-new-self-service-bi-scenarios-with-executequeries-support-in-power-automate/

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!