# Is there a way to pull in an excel spreadsheet in the cloud into a Power BI report directly without having to go through a server or personal computer?

Basically what I need help with is that I have Power BI reports connected to SQL server, then I also have to have it connected to my personal computer, and the Power BI report uses gateways on both the server and my personal computer because the server cannot get access to the Excel file needed.  It's super frustrating because if the personal computer gets turned off for some reason, then the whole report breaks and is extreamly frustrating to reset and have to re-schedule refreshes.  So, being able to host the Excel sheet in the OneDrive Cloud and then having Power BI just pull that file in from there would be extremely helpful.

##### Post Metadata
- Posted at: over 4 years ago
- Author title: Analyst
- Net upvotes: 3


## Comments
### Comment 1

Yes, Microsoft Power BI can directly connect to an Excel spreadsheet stored in the cloud without needing a personal computer or server in between. If the Excel file is stored in Microsoft OneDrive or SharePoint Online, Power BI can access it directly through cloud integration. This allows businesses to keep reports automatically updated whenever the Excel file changes. Users simply upload the Excel workbook to the cloud platform and connect it through the “Get Data” option in Power BI. Since the connection is cloud-based, there is no need to keep a local machine running for refreshes. This improves reliability and reduces infrastructure dependency. It also makes collaboration easier because multiple users can work on the same file from different locations. Businesses benefit from faster reporting, centralized data access, and simplified maintenance. Automatic synchronization ensures reports always reflect the latest information. Overall, this approach provides a scalable and efficient solution for modern business analytics workflows.

##### Comment Metadata
- Posted at: 3 months ago
- Author title: System Analyst



### Comment 2

ayradd_narif.imazighan@hotmail.fr
josh_119@hotmail.com
abde-hakimamazigh11@hotmail.com 

##### Comment Metadata
- Posted at: over 4 years ago
- Author title: Faq-ċhgha(فاق شغار)ⴼⴰⴰⵇ ⵛⵖⴰⵔ/rien de ches rien في hotmail+outlook(ⵀⵓⵜⵎⵉⵢⵍ+ⵓⵡⵜⵍⵓⵓⴽⵯ)هوتميل+أوتلوك




## Related Product
[Microsoft OneDrive for Business](https://www.g2.com/products/microsoft-onedrive-for-business/reviews)

## Related Category
[Cloud Content Collaboration](https://www.g2.com/categories/cloud-content-collaboration)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4