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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Community Champion
Community Champion

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.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

4 REPLIES 4
eriku
Regular Visitor

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

Screenshot_20221220_074039.png

otravers
Community Champion
Community Champion

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.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

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
Community Champion
Community Champion

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.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors