Forum Discussion
Keep Hyperlink clickable in Excel
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!
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
|