--- title: Use local files as Power BI data sources without configuring a Gateway description: If you build a report in Power BI Desktop and publish it to the Portal, you need to refresh the Dataset from time to time. But if one of your Data Sources is a local file, Power BI will force you to configure a Gateway for executing the refresh of the Dataset. image: https://blog.trusteditgroup.com/hubfs/Assets-Trusted%20IT/Tips%20and%20Tricks%20Images/39.webp --- Talk to us [** +1(941)5849323](tel:+19415849323) [Microsoft Project Online End-of-Life](https://www.trusteditgroup.com/project-online-end-of-life) [![trusteditlogo1](https://blog.trusteditgroup.com/hs-fs/hubfs/trusteditlogo1.jpg?width=621&height=220&name=trusteditlogo1.jpg) ![trusteditlogo1](https://blog.trusteditgroup.com/hs-fs/hubfs/trusteditlogo1.jpg?width=621&height=220&name=trusteditlogo1.jpg) ](https://www.trusteditgroup.com) [SCHEDULE A CALL](https://www.trusteditgroup.com/cs/c/?cta_guid=a8eebc56-91db-4088-9b99-71878eafa6b7&signature=AAH58kGnti2lHIaUMTAQVEuj8QMQW2OUAQ&portal_id=6338316&pageId=193532952956&placement_guid=87f5f48b-03d9-4f29-8089-749c05fa5529&click=b65bd78b-6d9d-4d91-9605-11d17ec2cd05&redirect_url=APefjpEl-QIvZiQGb-WlZTWzH6HeR2fPFeKCIb2qStt8hFtgA2EOKH6F7xSZXdl_WI3iEleuNTk05Wj4E8dObLKropc-Rl3dFZySxG_rG6lb0UY8NFXQBs8BE6KGftVcjfAwMgoV6hBH45d_HRspIAB4AH-Q6LX_tRZKPNcVuvtW3fdWB30z7VHBgRw9rhVyRYUaEBBjh5lY0RJLr225USh4yS3oCyEbTMC9g9wZDQLwllsYp9rLBJ-ZqtlZViutHgdSQoDXrMLbbayy1GROBQ1HBf6iflUEVQ&hsutk=d0268d6b01d5de2e2392d46a1b10c018&canon=https%3A%2F%2Fwww.trusteditgroup.com%2F&ts=1759770228681&__hstc=29662624.d0268d6b01d5de2e2392d46a1b10c018.1747992090013.1759765055885.1759769686116.56&__hssc=29662624.4.1759769686116) ###### 2 min read # [Use local files as Power BI data sources without configuring a Gateway](https://blog.trusteditgroup.com/tips-and-tricks/use-local-files-as-power-bi-data-sources-without-configuring-a-gateway) By [MEL](https://blog.trusteditgroup.com/tips-and-tricks/author/mel) on Feb 21, 2019 5:01:00 AM ###### Topics: [Tips](https://blog.trusteditgroup.com/tips-and-tricks/topic/tips) ![](https://blog.trusteditgroup.com/hubfs/Assets-Trusted%20IT/Tips%20and%20Tricks%20Images/39.webp) If you build a report in Power BI Desktop and publish it to the Portal, you need to refresh the Dataset from time to time. But if one of your Data Sources is a local file, Power BI will force you to configure a Gateway for executing the refresh of the Dataset. So, you need a computer or server, that should work 24/7 to set up the Gateway and have your Dataset always up-to-date. But if you have, for example, only one report pack, and only one Local Data Source like an Excel file, you probably don’t want to configure the Gateway and keep your computer working 24/7. So, you can use OneDrive for Business links in Power BI Desktop. It turns your Local Data Source into a Web Data Source and allows you to do the Dataset Refresh without configuring the Gateway. There are four easy steps to do this: 1. Store your Excel file in OneDrive; 2. Open the file stored in OneDrive in Excel; 3. Copy the file’s link from File > Info to clipboard; 4. Add new Web Data Source (Get Data > Web). Paste copied URL and remove the ?web=1 string  at the end of the link. Click OK. You can visit [https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links](https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links) to get more detailed information how to use OneDrive files in Power BI.   ![39](https://blog.trusteditgroup.com/hubfs/Assets-Trusted%20IT/Tips%20and%20Tricks%20Images/39.webp) Now your ex-local Excel file is a Web Data Source and you can always refresh the report without additional Gateway settings. Happy Learning. Best Regards,  Team of Managed Services Department Trusted IT Group support@trusteditgroup.com - [Tweet](https://twitter.com/share) #### Written by [MEL](https://blog.trusteditgroup.com/tips-and-tricks/author/mel) ###### [** Previous Post](https://blog.trusteditgroup.com/tips-and-tricks/how-to-display-the-specific-or-all-tasks-in-ms-project-calendar-view) [![](https://blog.trusteditgroup.com/hubfs/Assets-Trusted%20IT/Tips%20and%20Tricks%20Images/40.webp) ](https://blog.trusteditgroup.com/tips-and-tricks/how-to-display-the-specific-or-all-tasks-in-ms-project-calendar-view) ###### [How to display the specific or all Tasks in MS Project Calendar view](https://blog.trusteditgroup.com/tips-and-tricks/how-to-display-the-specific-or-all-tasks-in-ms-project-calendar-view) ###### [Next Post **](https://blog.trusteditgroup.com/tips-and-tricks/team-resources-in-project-online) [![](https://blog.trusteditgroup.com/hubfs/Assets-Trusted%20IT/Tips%20and%20Tricks%20Images/41.webp) ](https://blog.trusteditgroup.com/tips-and-tricks/team-resources-in-project-online) ###### [Team Resources in Project Online](https://blog.trusteditgroup.com/tips-and-tricks/team-resources-in-project-online) ##### Useful links Useful links ##### RESOURCES RESOURCES ##### HAVE QUESTIONS? HAVE QUESTIONS? **USA Headquarters:** 240 N Washington Bvrd., Suite 303,  Sarasota, FL 34236 Phone: [+1 941-584-9323](tel:+19415849323) Email: [info@trusteditgroup.com](mailto:info@trusteditgroup.com)   **Portugal Office:** Trusted IT Group Rua da Cooperativa Agrícola Bloco D, 4A 9050-555, Funchal Phone: [+351 965863641](tel:+351965863641) Email: [info@trusteditgroup.com](mailto:info@trusteditgroup.com) ##### Recent News ###### [Maximizing Efficiency with AI-Powered Project Management Software](https://blog.trusteditgroup.com/maximizing-efficiency-with-ai-powered-project-management-software) #### QuickSummary** / **KeyTakeaways - LeverageautonomousAIagentsforefficiency**.** Automating project... [**](https://www.facebook.com/trusteditgroup) [**](https://twitter.com/trusteditgroup) [**](https://www.linkedin.com/company/trusted-it-group-inc) [**](https://www.youtube.com/channel/UCEAcAr-IZ99bS5OPXS0gF3Q) [![Trusted IT Group](https://blog.trusteditgroup.com/hs-fs/hubfs/trusteditlogo1.jpg?width=85&height=30&name=trusteditlogo1.jpg "Trusted IT Group")](https://www.trusteditgroup.com/) Copyright © 2025 Trusted IT Group, Inc. **