Forum Discussion
Link to an Excel File with loading in the local Excel system
Hi all,
I don't know if it is possible.
The goal is that the user can click on a button or link in the Dashboard and after it it will be open an Excel File (.xlsb or .xlsm) directly in the local installed Excel Application (Not Webbased Version).
The File is located in a Sharepoint folder.
My problem, I can create an object in PowerBI with an Action (Web-URL) and add there the Sharepointfile. But when I press on the object, the Dashboard will download me the file and not open directly from the Sharepoint...
Thank you for your help and support
2 Replies
- negi007
Community Champion
flownfluid I attempted the same thing and I was able to create a text box and then link it to an xls file in a sharepoint folder. When clicking the text box, I was able to open the xls file directly from the sharepoint.
can you pl. explain the issue in more detail. Please note that xls file by default open in the browser but you can change the settings to open in the app. link below for help
Hi negi007,
thank you for your reponse.
I have activated now the setting to open all files in the client application.
When I open now the file from the Sharepoint directly, it opens in the Client Application, so the setting should work.
But I have still the problem with the link:
When the link looks like this:
https://..../Shared%20Documents/General/Test.xlsb
PowerBI download the file
When the link looks like this:
https://..../Shared%20Documents/General/Test.xlsb?web=1
PowerBI loaded the file from Sharepoint but in the Browser, even with the new setting
Can I add something to the link, that the file will be open from the client applicaiton and not from the browser
like "?Client=1" ?
Br
