cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jarlee17
New Member

Can't schedule refresh due to cannot find file with a file error handling

I've published a PowerBI file that is working on my desktop refreshing the data etc. but when i published it's not letting me refresh because it can't find the files.

Jarlee17_0-1617854349242.png


I'm getting my files from a folder path (csv) and from a database. The issue is, i've already accounted the missing files with a file error handler ,that if a file is missing or is not present on a folder, it will get data from a table. which is working fine if i do it on desktop. (see below)

Jarlee17_1-1617854544743.png

 

So trying to refresh will give me an error on the workspace Dataset settings. Has anyone encountered this issue?
any suggestions to resolve this?

thank you 



1 REPLY 1
_sfrost
Solution Specialist
Solution Specialist

@Jarlee17 

My guess is that the CSV file is not present in/accessible from your gateway machine.

You need to either install gateway on the machine where your CSV file is located or keep your CSV file in a shared drive so that the gateway can connect to your source file.

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!