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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors