Link to an Excel File with loading in the local Excel system

[flownfluid]

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

[flownfluid]

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

[negi007]

@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

How to default Office files to open in the native app from SharePoint and OneDrive - SharePoint Mave...