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

Refresh error

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

1 ACCEPTED SOLUTION
otravers
Super User
Super User

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.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog

View solution in original post

3 REPLIES 3
otravers
Super User
Super User

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.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog

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. 

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.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors
Top Kudoed Authors