How to use an excel file from local desktop to share with external users

Anonymous — Thu, 19 Mar 2020 00:04:23 GMT

Hi,

As part of my datasets some sources include excel files from my desktop. I've set up a gateway for my SQL data which works fine however I cannot seem to understand how to set up the excel file so that it automatically refreshes and is available to all my end users.

I've tried putting them in a sharepoint/onedrive folder and then using the direct link as the source data but I can't get it to work.

Could someone please advise on how to set up excel file correctly? Do I require a gateway and if so, how do I reference the excel file?

Re: How to use an excel file from local desktop to share with external users

KBO — Fri, 20 Mar 2020 07:41:39 GMT

Hi Anonymous ,

may be this link will help: https://radacad.com/change-excel-source-in-power-bi-to-onedrive-for-business-no-gateway-needed

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

topic How to use an excel file from local desktop to share with external users in Report Server

How to use an excel file from local desktop to share with external users

Re: How to use an excel file from local desktop to share with external users