Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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?

1 REPLY 1
KBO
MVP

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.