on 25 Jul 2018 13:21:42
Use Case: My data has a link which calls an application with certain parameters. When i fetch the data from excel, i can write a macro to show a button so that the respective application opens up and the link contents are hidden from the user.
With Power BI, we should be able to generate such an excel so that even the file URLs can work after exporting the data from table/matrix. Also if the column is tagged as a file URL, it should not be visible in the report but should appear in the extract.