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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
SewardExelon
Frequent Visitor

Refresh problem related to Virtual Machine version of a cloud file data source

i manage the Power BI gateway for my department; the "On-premises data gateway" is housed on a Virtual machine to which I have access.  All the folders to which I have access on my computer (Teams, Onedrive, etc) are also accessible inside the Virtual machine.  For some of our Power BI Dashboards, we have FOLDER data sources, the folders contain excel files that are some of the data sources for some of the PBI Dashboards.   When I update the excel file or add an excel file in the FOLDER data source, the version of the file on the Virtual machine has a BLUE CLOUD icon under Status.  Until this BLUE CLOUD is changed into a GREEN CHECKMARK, the Power BI dashboard that uses the Folder/File will not refresh.  As of now, the only way I can turn the BLUE CLOUD into a GREEN CHECKMARK is by opening and closing the file.   This is not good since I'm the only person with access to the Virtual machine.   SO, I'm wondering anyone in this community has a solution for this problem?  Thanks in advance.

 

SewardExelon

1 REPLY 1
lbendlin
Super User
Super User

In such a scenario do not use the Folder connector. Use the Sharepoint Folder connector.

 

Not sure how this is related to the gateway though?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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