Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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!