Refresh error

[Ras44]

Hello,

I am experiencing issues with my dataset refreshing. I am not experiencing any issues in my desktop version, however once I publish the report to app.PowerBI.com I am no longer able to manually or automatically refresh. I receive this message, "You can't schedule refresh for this dataset because the following data sources currently don't support refresh:" I'm sourcing a local Excel file with a pivot table that is pulling data from a second excel file. There are no crednetials needed for either files they are both public. There are no functions or equations in the pivot table, the first excel sheet does the equations so the second one (the one I'm pulling from) only has the raw data. 

Can this be fixed?

Thank you,

Collin

[eriku]

I'm having a similar issue. can't seem to figure it out. does anyone have any thoughts?  

[otravers · Accepted solution]

If you want to refresh local files from the Power BI service, you need to install the Power BI data gateway on your PC. It's usually easier (i.e. no gateway needed) to sync the files to OneDrive or SharePoint and refresh the files from there.

[Ras44]

Oh ok, that would explain why I've never had this issue with my sharepoint data sources. Thank you for the help! Is it relatively simple to install the data gateway? I clearly haven't yet. 

[otravers]

Yes, unless you're moving a lot of data through the data gateway (which may introduce the need for clustering), at a small scale it's a fast and easy install. You'll have to update it in the future to keep up with Power BI Desktop updates, but that's again pretty straightforward.